Dear All,
Using conditional formatting, I want to fill red those dates which fall on Sundays.
Attachment is file wherein i used weekday formula but without avail.
Kindly help on the topic.
Regards
Dastgir
Dear All,
Using conditional formatting, I want to fill red those dates which fall on Sundays.
Attachment is file wherein i used weekday formula but without avail.
Kindly help on the topic.
Regards
Dastgir
You were close you just need to change the formula to
=WEEKDAY(A2)=1
it will adjust for each cell in the range
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks