Get instant live Excel expert help to learn how to use conditional formatting to highlight cells less than or greater than some value

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello I was wondering if theres a way to use conditional formatting on a cell that is controlled by a sum of other cells for example a1+a2 is less than a3 then a3 turns one colour and a1+a2 is greater than a3 then a3 turns another colour. many thanks
Solved by S. U. in 27 mins
Hello, I am looking to highlight the cells that have text in them to highlight as red between the 1st through the 15th of every month, and then be green the 16th through last day of the month whether it be the 30th, 31st, or even 28th (depends on the month). I attached a sheet in which I was testing by highlighting all of the cells with text (the 1 of 8, 2 of 4, etc.) then clicking "Conditional Formatting" > "Highlight Cells Rules" > and then either Greater Than or Less Than for both red and green using the following formulas for each month: Less Than (Red): 2017-08-15 2017-09-15 2017-10-15 2017-11-15 2017-12-15 Greater Than (Green): 2017-08-15 2017-09-15 2017-10-15 2017-11-15 2017-12-15 I am not sure what I am doing wrong but when I did the formula and chose the colors for August, it seemed to work fine, being today's date would be within the right date range for the cells to highlight as green. I then removed the August formulas and replaced them with September formulas, it did not seem to work.
Solved by C. W. in 14 mins
i would like to do a conditional formatting to my cells. i would like cells O2-O27 to highlight if they are greater than cells N2-N27. How can I do this?
Solved by B. F. in 28 mins
i need to do a conditional formatting rule for greater than.
Solved by I. B. in 23 mins
The spreadsheet is being used to track attendees to courses. So when they confirm a date it goes in Collum G I would like to get conditional formatting to do the following: White if greater than 15 days Orange if between 3 – 14 days Green if today – 2 days My current conditional formatting for those cells are: White:Cell Value > =NOW()+15 Orange: Cell Value between =NOW()+3 & =NOW()+14 - Green: Cell Value between =NOW() & =NOW()+2
Solved by I. J. in 29 mins
I have a problem that I need help with. I am trying to use Conditional Formatting to highlight one cell against another cell using greater than, equal to, and less than. The cell I want highlighted gets its value using a formula that gathers data from multiple areas in the spreadsheet. This seems to be the cause of my trouble. The cell I want to compare it to is a static number. For some reason no matter what I do I cannot get the cell containing the formula to highlight correctly. Ive tried all variations of =g3<>h3 but for some reason it will not work. (G3 is the cell that has a value obtained from a formula) What I am looking for is when G3 is less than H3 then G3 gets highlighted red. When G3 is greater than H3 then G3 gets highlighted green. When they are equal G3 stays white. PLEASE HELP! I've spent 3 hours on this already.
Solved by G. L. in 25 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
How to write a conditional formatting formula which will apply formatting to C2 IF: C2 contains a value which appears more than once in column C AND ( G2 does NOT contain the text "0001-01-01" OR F2 value is greater than 7/24/17)
Solved by S. Q. in 28 mins
I want to conditional format an entire worksheet, where if the value in a cell is greater than the value in B of that row, the cell is highlighted. However, per line, the value in B is VARIABLE. Example: if in B2, the value is 100, any values in row 2 higher than this will be highlighted. If in B3, the value is 200, any values in row 3 higher than 200 will be highlighted. Values less than 200 but over 100 should not be highlighted in row 3, as they should NOT be affected by the formatting copied down from row 2. Conditional formatting needs to understand the X variable for Greater Than in column B is changing PER ROW. I can make this work by clicking each row and applying formatting manually, however there are several thousand lines of data to format, and I need this to go quicker.
Solved by B. F. in 27 mins
I am looking at getting a conditional formatting equation set up where it is based off if the cell above is greater than or less than. And I am looking at trying to have this for thousands of cells so I do not have to do it for each individual cell, I could just drag it down or use the format painter.
Solved by O. A. in 17 mins
2