Forum Discussion
Excel conditional formatting
Please help with conditional formatting rules. In our unit the trainer can not be the same as the certifier. I manually colored it to what I wish to see. Thank you a TON in advance!!
- Select cells in column G, starting from row 4
- Choose Home, Conditional Format, New Rule, set these options:
- Repeat step 1 and 2, this time set it to this:
NB: My screenshots were taken before looking closely at yours. The 2's in my conditional format rule formulas must be replaced by 4's.
alternatively I would recommend highlighting all those cells and making the red and then only have 1 conditional formatting rule to make it green (or vice versa)