How can I make a cell color RED under the Today's date cell?

Learner7 · #1 07-07-2010, 04:50 AM

Hi,

I have Current date in Cell A1. and

Row 1 conatains dates starts from 1st July to 31st July. Each date contains only one date. So, there are 31 Cells filled with dates in Row 1.

And what I want now is, the below Cell of Current date should get RED Color. It means everyday the other cell get RED.

How it is possible. Please advise.

Thanks.

ConneXionLost · #2 07-07-2010, 08:41 AM

Try this.

Cheers,

Learner7 · #3 07-08-2010, 12:52 AM

Quote:

Originally Posted by ConneXionLost

Try this.

Cheers,

Thanks for the file. But how can I do this in any Excel Sheet wherever I need to use this kind of formatting.

Thanks again for the help.

I got it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filtering on cell color	mattc	Excel	1	04-30-2010 09:27 AM
Extracting Cell color	bsaucer	Excel	1	06-19-2009 06:52 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM
Imported message date change to today's date	promark	Outlook	1	12-23-2005 07:21 AM