Thread: How can I make a cell color RED under the Today's date cell?
View Single Post
 
Old 07-07-2010, 04:50 AM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default 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.
Reply With Quote