Conditional Formatting cells to specific colors

[VisionSmart]

Hello all,

Trying to set format for following conditions

If any blank cell in range F4:F153, then cell remains blank.
If any cell containing data in range F4:F153 < D4:D153 then Red (RGB 255:0:0) – white Font
If any cell containing data in range F4:F153 > D4:D134 then Green(RGB 0:255:0) – Black Font

I keep getting all Red cells. - See attached WBook.

[FDibbins]

So you are testing F4 against D 4, F5 against D 5 etc?

If so, then just test for =F4 < D4
etc

Then test for =F4 > D4

Now, what about if the values are =?

[FDibbins]

I had the opportunity to open your file and look at your date.

1. you say F18 should be green, but F4 < D4?

For green...
=AND(F4<>"",F4>D4)

For red
=AND(F4<>"",F4<D4)

Again, what if they are =?