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

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2010, 04:50 AM
Learner7 Learner7 is offline How can I make a cell color RED under the Today's date cell? Windows XP How can I make a cell color RED under the Today's date cell? Office 2007
Advanced Beginner
How can I make a cell color RED under the Today's date cell?
 
Join Date: May 2010
Posts: 47
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
  #2  
Old 07-07-2010, 08:41 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline How can I make a cell color RED under the Today's date cell? Windows XP How can I make a cell color RED under the Today's date cell? Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Try this.

Cheers,
Attached Files
File Type: xls ConditionalCurrentDate.xls (22.0 KB, 14 views)
Reply With Quote
  #3  
Old 07-08-2010, 12:52 AM
Learner7 Learner7 is offline How can I make a cell color RED under the Today's date cell? Windows XP How can I make a cell color RED under the Today's date cell? Office 2007
Advanced Beginner
How can I make a cell color RED under the Today's date cell?
 
Join Date: May 2010
Posts: 47
Learner7 is on a distinguished road
Default

Quote:
Originally Posted by ConneXionLost View Post
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.

Last edited by Learner7; 07-08-2010 at 02:01 AM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make a cell color RED under the Today's date cell? Filtering on cell color mattc Excel 1 04-30-2010 09:27 AM
How can I make a cell color RED under the Today's date cell? 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
How can I make a cell color RED under the Today's date cell? Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM


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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft