Color and Date

  • Thread starter Thread starter cnalaka
  • Start date Start 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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Color of cell 3
How to filter rows data based on background color of individual cells 1
Conditional Formatting 5
Conditional Formating based on Date 5
Excel date format YYYYMMDD 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
help with datdiff and conditional format 1
For Sale 8Gb DDR3 memory 3

Back
Top