Highlight the column you want to change the appearance of
and under Format, Conditional format put =C2F2 in the
Formula is section, then pick a format and OK.
-----Original Message-----
I am trying to use conditional formatting comparing one
range of cells to
another range. For example - C2:C100 compared to F2:F100
respectively -
I am wanting to format the cell to tell me if C2 F2 and
C3 F3 and so on.
I can't seem to figure it out.
Thanks,
Peggy
.
|