View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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