• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting - change color based on Dates / DOW

Dear Excel Gurus,

In the attached document I have entered Date in cell A1, formula added in cell B1: AE1.
Based on values in cell A1:AE1 cells A2:AE2 values display "ddd" format.
Conditional formatting has been done in cell A2:AE2 to change color based on Weekday and Weekend. (Fr & Sat) being considered weekend, rest weekday.

I want cell A1:AE1 also to have conditional formatting with the same above mentioned Weekend/Weekday color pattern.
How can I set this as in future value of A1 will change.

Appreciate your feedback.

Kind regards
 

Attachments

  • Conditional Format.xlsx
    10.5 KB · Views: 4
First apply the format you wish to see for weekdays. Both rows can then be conditionally formatted with the same formula
= WEEKDAY(A$1)>5
 

Attachments

  • Conditional Format.xlsx
    10.2 KB · Views: 6
Back
Top