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 should both be be "Green", however if Column C date is greater than Column D date they should both be "Red"
Thanks in advance.
Scott
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
3 Replies
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
- 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
