Cell Colors
 

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.

Cell Colors
 

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



On Feb 9, 2:16*am, Peter wrote:
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.

Cell Colors
 

Use conditional formatting with formulae of

=WEEKDAY(A1)<3

=AND(WEEKDAY(A1)3,WEEKDAY(A1)<6)

--
__________________________________
HTH

Bob

"Peter" wrote in message
...
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.