How do I format a background color with a cell formula?
Posted on 2011-04-21
I have a cell (A1) that displays the “Tab Name”. The tab name is a date (for each day of the month), eg. 11-04-18.
Each day of the week has a different color associated with it:
Mon – Yellow
Tue – Blue
Wed – Pink
Thur – Gold
Fri – Green
I want to program this cell with a formula to change background color based on the day of the week for that date. Eg. 11-04-08 is background color Yellow; 11-04-19 is Blue.
First, can I do this with a cell formula, and then where do I start?
Would it be easier to program a background color for the actual tab?
What would you recommend?