Conditional Formatting
 

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.

Conditional Formatting
 

Try this. Use Formula Is for all conditions.

Condition 1: =OR(WEEKDAY(A1)=1,WEEKDAY(A1)=2) for Sun and Mon

Condition 2: =OR(WEEKDAY(A1)=4,WEEKDAY(A1)=5) for Wed and Thurs

Condition 3: =OR(WEEKDAY(A1)=3,WEEKDAY(A1)=6,WEEKDAY(A1)=7)
for Tue, Fri, and Sat

For each, set your background color you wish to use.

Les

"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.

Conditional Formatting
 

Try this. Use Formula Is for all conditions.

Condition 1: =OR(WEEKDAY(A1)=1,WEEKDAY(A1)=2) for Sun and Mon

Condition 2: =OR(WEEKDAY(A1)=4,WEEKDAY(A1)=5) for Wed and Thurs

Condition 3: =OR(WEEKDAY(A1)=3,WEEKDAY(A1)=6,WEEKDAY(A1)=7)
for Tue, Fri, and Sat

For each, set your background color you wish to use.

Les

"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.

Conditional Formatting
 

Try this. Use Formula Is for all conditions.

Condition 1: =OR(WEEKDAY(A1)=1,WEEKDAY(A1)=2) for Sun and Mon

Condition 2: =OR(WEEKDAY(A1)=4,WEEKDAY(A1)=5) for Wed and Thurs

Condition 3: =OR(WEEKDAY(A1)=3,WEEKDAY(A1)=6,WEEKDAY(A1)=7)
for Tue, Fri, and Sat

For each, set your background color you wish to use.

Les



"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.

Conditional Formatting
 

Try this. Use Formula Is for all conditions.

Condition 1: =OR(WEEKDAY(A1)=1,WEEKDAY(A1)=2) for Sun and Mon

Condition 2: =OR(WEEKDAY(A1)=4,WEEKDAY(A1)=5) for Wed and Thurs

Condition 3: =OR(WEEKDAY(A1)=3,WEEKDAY(A1)=6,WEEKDAY(A1)=7)
for Tue, Fri, and Sat

For each, set your background color you wish to use.

Les

"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.

Conditional Formatting
 

Sorry for multiple post. I kept getting an error saying post was not received.

Les

"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.

Conditional Formatting
 

Hi,

This is not too subtle but Les' postsssssss should get the point across.

However, folks, I keep hearing that posts are not showing up on the web
interface, personally, I'm using the web interface with Yahoo and everything
is fine. Well, not everything, but I am seeing the posts.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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.