Help with conditional formatting

Marcus Coates

New member
Joined
Sep 11, 2012
Messages
12
Reaction score
0
Points
0
Hi I am trying to use the greater than or equal to function to highlight a cell when that value is greater than or equal to another cell. For some reason though it highlights the column I have applied the formatting to unless there is actually a lower value does it not highlight the cell. I have several empty cells although formulas are written in them I would assume that when they are blank that the cell would not be highlighted
 

Kev@Radstock

New member
Joined
Sep 25, 2012
Messages
6
Reaction score
0
Points
0
Hi MarcusCoates

Use the AND function. For the example below in the conditional formatting

=AND($A1<>"",$D$1>=$A1)
 

Kev@Radstock

New member
Joined
Sep 25, 2012
Messages
6
Reaction score
0
Points
0
Hi

If you are using Excel 2007>. Select the cells,column/s, row/s where you need to apply the conditions. Then on the home tab. Conditional formatting > New rule > Use a formula to determine which cells to format > place your formula in the Format values where this formula is true > format as required.


CF dialogue box.PNG
 
Last edited:

Marcus Coates

New member
Joined
Sep 11, 2012
Messages
12
Reaction score
0
Points
0
Thanks that has worked but why does doing the simple greater or equal formula not work?
 
Top