Cell Colors

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I have one cell that is the date plus 1. What I need to do if the cell's date
is Sun or Mon then I want it to change the background to green. If it is Wed
or Thurs I want it to be blue. If it is a Tue. Fri or Sat I want it to be
white. I have tried many different formulas to change this and still can't
figure it out. Any help is appreciated.
 
Assumed value is cell A1.

Select the cell | go to format | conditional format | condition 1 :
formula is =WEEKDAY(A$1)<=2 | choose color |
condition 2 : formula is : =OR(WEEKDAY(A$1)=4,WEEKDAY(A$1)=5) | choose
color | ok
 
Use conditional formatting with formulae of

=WEEKDAY(A1)<3

=AND(WEEKDAY(A1)>3,WEEKDAY(A1)<6)
 
Back
Top