Color and Date

C

cnalaka

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?
 
D

Dave Peterson

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.
 
Top