conditional formatting comparing columns

  • Thread starter Thread starter SGM
  • Start date Start date
S

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...
 
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.
 
Back
Top