A aksalim New Member Jul 23, 2019 #1 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.
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.
Luke M Excel Ninja Staff member Jul 23, 2019 #2 Since Sunday is WEEKDAY = 1, we can use a CF formula like this on cell A2 =WEEKDAY(A2)=1
A aksalim New Member Jul 23, 2019 #3 Luke M said: Since Sunday is WEEKDAY = 1, we can use a CF formula like this on cell A2 =WEEKDAY(A2)=1 Click to expand... I will rry
Luke M said: Since Sunday is WEEKDAY = 1, we can use a CF formula like this on cell A2 =WEEKDAY(A2)=1 Click to expand... I will rry
A aksalim New Member Jul 23, 2019 #4 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?
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?
