Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-07-2010, 04:50 AM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2010
Posts: 45
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 Windows XP 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 Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2010
Posts: 45
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
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


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft