Conditional formating for weekdays
 

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

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

Conditional formating for weekdays
 

maybe

Conditional Formatting
formula is :=weekday("this cell")=2

driller