Excel - ExcelBanter

dipsy

Posts: n/a

Excel

Hi! I have a column full of dates. I want to do the
following based on dates:

1. If date is Feb-05 - then I want to color only Qtr1
cell.
2. If date is Dec-05 - then I want to color Qtr1, Qtr2,
Qtr3 & Qtr4.

Is there a way to do it?

Thanks.

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
How do I isolate my Excel server (automation) from other Excel instances?	Joseph Geretz	Excel Discussion (Misc queries)	5	July 19th 13 03:18 PM
VB Automation is Whacking out my Excel Environment	Joseph Geretz	Excel Discussion (Misc queries)	2	December 29th 04 03:49 PM
Excel 2000 file when opened in Excel 2003 generates errors?	Doug	Excel Discussion (Misc queries)	13	December 25th 04 10:20 PM
Excel aficionado wants to learn Access	Hari	Excel Discussion (Misc queries)	0	December 3rd 04 05:47 AM

All times are GMT +1. The time now is 09:56 PM.

Menu

About Us