Get instant live Excel expert help with conditional formatting
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I would like assistance setting up conditional formatting for over 5% and over 10%
Solved by F. Y. in 20 mins
Hello
I would like to highlight entire row of a table if one cell in row equals yesterday. I do not know how to do it with conditional formatting.
Solved by F. H. in 24 mins
My report has a formula that changes text in "L" column based on the date (column "K" being greater than 300 days. I want to highlight and change column "L" text if date in column "K" is greater than 30 days past date.
I'm not sure if this can even be done in conditional formatting or if it will work better in VBA,
Any help would be WONDERFUL!
Thank you!
Solved by Z. B. in 28 mins
I used the project plan template in excel, but when I copy and paste into another tab, the conditional formatting does not work on the new tab. How do I paste into the new tab and maintain the conditional formating?
Solved by Z. F. in 25 mins
Conditional formatting
Comparing dates in two columns, need the date to remain black if completed ahead of schedule, this conflicts with the late rule as blank cells are considered and earlier date.
Solved by C. F. in 28 mins
Trying to format excel with conditional formatting. i can get it to work but want to except the first 2 rows.
Solved by V. U. in 19 mins
I’m trying to use conditional formatting to create rules for cells to color code blue or red when values are either lesser or greater.
Columns C7-17 and F7-17 are comparing to each other.
Columns C24-50 and F24-50 are cells that allow my conditional formatting to work.
Ultimately, cells F7-17 are color coded based on comparing to cells C7-17, with the work to allow this formatting following below.
Looking at the attached, I need help formatting the cells F8, F10, and F12.
Rules I’m struggling on in these three cells:
F8: If value is comparing a $ figure to text None, the None cell should be blue.
F10: If value is comparing None to $ value, the $ value should be red.
If value is comparing % to $ value, $ value should be red.
Solved by I. H. in 13 mins
how can i see all the conditional formatting in a workbook
Solved by B. Q. in 11 mins
I am looking to create a PM Report similar to the "PM Chart" worksheet in the file uploaded. Also, not sure why my "Project Status" column won't show "yellow" as conditional formatting?
Solved by B. W. in 26 mins
Column 'D' (TechOps Dashboard), needs conditional formatting to show: Green=Complete, Yellow=On Target, Red= At Risk and Gray= On Hold
Solved by O. C. in 12 mins