Hi MarcusCoates
Use the AND function. For the example below in the conditional formatting
=AND($A1<>"",$D$1>=$A1)
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
Hi MarcusCoates
Use the AND function. For the example below in the conditional formatting
=AND($A1<>"",$D$1>=$A1)
Do I enter that into the conditional format bar?
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.
![]()
Last edited by Kev@Radstock; 2013-01-27 at 03:19 PM.
Thanks that has worked but why does doing the simple greater or equal formula not work?
Bookmarks