Forum Discussion
Solved
** HELP ** CONDITIONAL FORMATTING
hi All Its been a while since i done any conditional formatting and seem to have forgotten how to do the simplest of tasks: So, what I'm after is that if Column C date matches Column D they s...
It shall be two rules (one for each color) with rules formulae
Green: =$C2=$D2 Red: =$C2>$D2applied to entire range of these columns within the table, e.g. to $C$2:$D$100
It shall be two rules (one for each color) with rules formulae
Green:
=$C2=$D2
Red:
=$C2>$D2
applied to entire range of these columns within the table, e.g. to $C$2:$D$100
Thanks for responding Sergei, this is where i require a little bit of hand holding how do i apply these rules/formulae on Excel.
sruk89 , you are welcome