I have an excel sheet (excel 2003) and it contains data as follows:
a) column A contains name
b) column B contains IDs
c) C1: date, C2=weekday based on date, C3: For each of the corresponding name, it contains some plain text (basically work activity, like Project1, Meeting, Leave etc)
c) repeat "C" format for all subsequent columns.

There are a total of about 50 names (column A) and hence 50 corresponding IDs (column B) and so on.

Now, I require the following:
a) If the day is "Saturday" (it will be in C2), then color the column from C3:C50 in GREY color (or any other color)
b) If the day is "Sunday" (it will be in C2), then color the column from C3:C50 in GREY color (or any other color)
c) all other weekdays, needs to be colored blue.

I will keep adding columns every day and the above formatting should apply.

Hope someone helps me.