Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 7th 04, 09:57 PM
Rich
 
Posts: n/a
Default Turn cell red if today is greater or equal to date in cell

Hi,
I'm storing dates in cells in a column that represent future deadline
dates. If today's date is greater or equal to the date stored in the cell,
I want to turn that same cell red and text bold. Or, at least somehow flag
it.

I've been using conditional formatting but have not been able to get
exactly what I need. Thank-you,

Rick

(remove X's for true email)



  #2   Report Post  
Old December 7th 04, 10:00 PM
Frank Kabel
 
Posts: n/a
Default

Hi
- goto the conditional format dialog after selecting your cell (lets
say you have selected B1)
- choose 'Formula is'
- enter the following formula:
=B1<=TODAY()
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany

"Rich" schrieb im Newsbeitrag
...
Hi,
I'm storing dates in cells in a column that represent future

deadline
dates. If today's date is greater or equal to the date stored in the

cell,
I want to turn that same cell red and text bold. Or, at least

somehow flag
it.

I've been using conditional formatting but have not been able to

get
exactly what I need. Thank-you,

Rick

(remove X's for true email)



  #3   Report Post  
Old December 7th 04, 10:50 PM
Rich
 
Posts: n/a
Default

It worked perfect.
Thank-you,

Rick

"Frank Kabel" wrote in message
...
Hi
- goto the conditional format dialog after selecting your cell (lets
say you have selected B1)
- choose 'Formula is'
- enter the following formula:
=B1<=TODAY()
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany

"Rich" schrieb im Newsbeitrag
...
Hi,
I'm storing dates in cells in a column that represent future

deadline
dates. If today's date is greater or equal to the date stored in the

cell,
I want to turn that same cell red and text bold. Or, at least

somehow flag
it.

I've been using conditional formatting but have not been able to

get
exactly what I need. Thank-you,

Rick

(remove X's for true email)







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date format within a cell containing a formula Brushie76 Excel Discussion (Misc queries) 1 January 22nd 05 03:50 AM
Formula with text and reference to a date cell [email protected] Excel Discussion (Misc queries) 1 January 11th 05 08:15 AM
How do I stop today() from updating date on saved spreadsheets? lionmark Excel Discussion (Misc queries) 2 January 4th 05 01:03 AM
How would I change a date cell to decrease it by business days? CNGracin Excel Discussion (Misc queries) 3 December 15th 04 05:20 PM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 02:48 AM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017