Help with conditional formatting

**Marcus Coates** · 2013-01-27, 01:35 PM

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** · 2013-01-27, 01:51 PM

Hi MarcusCoates

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

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

**Marcus Coates** · 2013-01-27, 02:35 PM

Do I enter that into the conditional format bar?

**Kev@Radstock** · 2013-01-27, 03:13 PM

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.