FORMULA FOR DATES

[hsarrategui]

I can't find anything on google for what I am trying to do. I have column "B" that has the date (00/00/0000) and column "C" has =TEXT(B3, "dddd") to reflect the day of the week the "date" is. Column C shows different days depending on the date and I was hoping I could make each day of the week a different color when it auto populates the day of the week from the date in column B. If that makes sense? I have added a screen shot so you can see what I am talking about

 

[Joe4]

Are you using Excel or Google Sheets to do this?

You should be able to use Conditional Formatting where you can set 7 rules, one for each day of the week, with a different color for each one.

 

[hsarrategui]

Are you using Excel or Google Sheets to do this?

You should be able to use Conditional Formatting where you can set 7 rules, one for each day of the week, with a different color for each one.

I am using excel. I've tried different formulas but nothing is working

 

[Joe4]

Here is an example of how you would do the first rule:

1. Select the range starting with cell C3 and going to your last populated cell in column C
2. Go to Conditional Formatting
3. Select the "New Rule" option
4. Select "Use a formula to determine which cells to format" option
5. Enter in the following formula:

=C$3 = "Friday"

6. Click on the "Format" button
7. Go to the "Fill" tab and select your desired format color
8. Click "OK"

Then, you would just repeat the steps above for the other days of the week and other colors.