Hello, How to bypass the 3 conditional formatting limit by using the IF or OR function?
I am editing an .xls file and there is a limit to 3 conditional formatting rule for coloring a cell.
How do I combine the conditions using a formula?
On the test file there are salary grades. When an employee selects a salary grade on the dropdown box I want the adjacent box to turn red.
However there are 5 dropdown choices. How do I use the IF or OR formula on this one?
Please look at the test file.
Thanks
Bookmarks