Conditional Formatting

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

 

[WLMPilot]

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

 

[WLMPilot]

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

 

[WLMPilot]

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

 

[WLMPilot]

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

 

[WLMPilot]

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

Les

 

[Shane Devenshire]

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.