• 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 Formating

aksalim

New Member
How can I use the conditional format to change colour of cell provided with a date based on day of a week.
Eg, I have dates of events in a column, I need to format colour of the dates those are Sunday.
 
I will try.
I tried the other CF option,=text(a2,"dddd")="Sunday" , but, somehow it didn't work. Is there any error in the above formula?
 
Back
Top