Conditional Formatting

  • 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.
 
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
 
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
 
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
 
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
 
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.
 
Back
Top