[mso] Re: Excel - Enter today's date?

Just to add to what Anne says...as Ray said, you don't really need to put
the =TODAY() formula in a different cell if all you want is to use your
conditional format to color cells later than today.

In the Conditional Formatting box, just choose "cell value is" "greater
than" and enter  =TODAY() in the last box.


Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV.  If you got a bug that looks like
it came from me, it did NOT!

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Anne Robson
Sent: Friday, February 27, 2004 3:38 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel - Enter today's date?

Hi Dian

I can help with this one! (g) - you need the Today function.  Create a
cell (it can be a hidden cell if you don't want to display the date on the
sheet for any other reason) with the following function: =TODAY()

Then enter your date data details (argghh tongue twister!!) in their
respective columns, make sure they are formatted as date cells.  Then
click on the column headings and conditional format so that if your date
data is greater than [click on the cell with the +TODAY() function} the
background or text is coloured the way you want it.  It's dead easy and
really dynamic and functional (pardon the pun).

You can even get really clever and make another condition whereby if the
date has been passed by a certain factor the colour changes again!

Cool huh?

Hope you are well - you and I have been about as absent as one another
lately!

Anne
xxx


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: