conditional formatting comparing columns

[SGM]

I am trying to compare two columns containing dates, B &
C, and have Column D's adjacent cell highlighted through
conditional formatting if B > C. (This will alert the
user that they need to input data into column D)

I am using the formula is function within Conditional
Formatting, but cannot get the formula to work when I am
trying to apply it to the entire column D. My formula is:

=$B:$B>$C:$C

This works perfectly when I apply the formula to
particular cells:

=$B$15>$C$15

Any ideas? Thanks...

 

[Frank Kabel]

Hi
try the following:
- select the cells in column D (assumption you start with D2)
- goto the conditional format dialog and enter the following formula
(for all selected cells)
=$B2>$C2

the row index will change automatically for the other rows. just enter
the formula with a relative row index.

 

[SGM]

Hi - THANK YOU!!! Works like a charm and you saved my
sanity.