How can I use an IF statement to change cell background color format where more than 3 color options are needed?
Posted on 2011-03-14
I need help formatting a cell to display a different color for each day of the week:
I’m thinking of something like this:
Cell A2 contains the day, e.g. Mon. Cell B2 is a formatting formula for cell A2, e.g.:
Can I do this? (Conditional formatting in my Excel 2003 limits me to 3 conditions.)
If not, is there a workaround? (I would prefer not to use VBA.)