Conditional formatting

[Brian from Maui]

Good Morning,

I have in row 1 dates, 1,2,3 etc.
In row 2 I have days, mon, tue, wed, that corresponds to row 1. In row 3, I would like to shade days off, and not necessarily sat/sun, but also mon/tue etc. The month does not matter. Can the shading be done by using a condtional format, instead of clicking the cells and formatting them manually? Mahalo.....

Brian
This message was edited by Brian from Maui on 2002-02-24 07:00

 

[Brian from Maui]

Aloha Jack,

You're right, it is raining!!!!

Thanks for the offer, but being new to Excel, I'd like to stay away from VBA. I have a hard time with formula functions.

Brian

 

[Jack in the UK]

HI

Cool no dramas - let me know if ican ever help private might be best or mail at work.

Take care friend

 

[]-[ /-\ \/\/ /-\ | | /-\]

Hawaiian Brian,

Sorry, no useful info...(haha)...just wanted to give a shout out...good to find a fellow kamaaina here...

Aloha!