Conditional formating for weekdays
Conditional Formatting
=TEXT(WEEKDAY(A2,1),"dddd")="Monday"
"Diogo" wrote:
Hi
Need some help: How do I create a conditional formating that changes the
background color of a cell if that cell contains a date that correspondes to
a Monday, I know I have to use something like weekday=2....
Thanks
|