View Single Post
  #1   Report Post  
Patrick
 
Posts: n/a
Default Conditional formatting

I have formatted cells with a date entered in them have custom format of
'dddd' this will give the day of the week, no problem.

The difficulty I hace now is that I want 'Saturday' and 'Sunday' to have
conditional formatting so the cells change colour. I can not seem to get this
to work with either cell = Saturday or formula = Saturday.

Please help! Am I doing something wrong or is there another way to get this
to work?

Many Thanks