Conditional Formatting for days of the week

[bryanhope]

Hello I want to format a row color based on the day of the week,the date doesnt matter just the day of the week what formula would I use in this scenario? Thanks

Example: Monday = blue, tuesday = green, wednesday = yellow, thursday = purple, friday = orange etc

[Jdevil]

With the WEEKDAY function, which returns a number between 1 and 7, you should be able to do it

[63falcondude]

Hello, welcome to the forum.

You will have to create one Conditional Formatting rule for each color. Is the day of the week entered (e.g. "Monday") or a date (e.g. 6/19/2017)?

If a date is entered, consider using WEEKDAY as Jdevil suggested. If you need more specific assistance, consider uploading a sample worksheet along with the desired results of the Conditional Formatting.

[Amanda Wilso]

Highlight your rows the Format>>Conditional Format>>Formula is
=(WEEKDAY($A1)=1) choose the color format, and repeat it until 5, changing the color as you want.