Posted to microsoft.public.excel.misc

Peter

external usenet poster

Posts: 349

Cell coloring

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
coloring a cell if blank	Karenobrn	Excel Worksheet Functions	5	August 18th 08 10:15 PM
Cell coloring according to the other cell's value	Sore	Excel Worksheet Functions	2	January 25th 08 05:24 PM
Cell Coloring	supersub15	Excel Worksheet Functions	2	October 26th 07 04:12 PM
conditional cell coloring	phrodude	Excel Worksheet Functions	5	July 28th 06 12:15 AM
Coloring Active Cell	Carroll	Excel Worksheet Functions	8	September 30th 05 12:45 PM

All times are GMT +1. The time now is 02:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us