Color and Date
 

I have date column and i need Friday in red color and rest of the week days
in blue color
How can I do that?

Color and Date
 

Format all the range as blue (font or fill???).

Then you can use format|Conditional formatting (xl2003 menus) to color the reds.

Select the range
Format|Conditional formatting
Formula is: =WEEKDAY(A1)=6

Change A1 to the activecell's address.



cnalaka wrote:

I have date column and i need Friday in red color and rest of the week days
in blue color
How can I do that?

--

Dave Peterson