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

		Microsoft Office Forums > Microsoft Excel > Excel
How can I make a cell color RED under the Today's date cell?

FAQ

Thread Tools

Display Modes

07-07-2010, 04:50 AM

Learner7

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

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

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

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:11 PM.