Help with conditional formatting

[Marcus Coates]

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]

Hi MarcusCoates

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

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

[Marcus Coates]

Do I enter that into the conditional format bar?

[Kev@Radstock]

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.

[Marcus Coates]

Thanks that has worked but why does doing the simple greater or equal formula not work?