Turn cell red if today is greater or equal to date in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rich - 07 Dec 2004 21:57 GMT

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

onlineXmanX@exciteX.com (remove X's for true email)

Reply to this Message

Frank Kabel - 07 Dec 2004 22:00 GMT

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

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Hi,
> I'm storing dates in cells in a column that represent future deadline
[quoted text clipped - 8 lines]
>
> onlineXmanX@exciteX.com (remove X's for true email)

Reply to this Message

Rich - 07 Dec 2004 22:50 GMT

It worked perfect.
Thank-you,

Rick

> Hi
> - goto the conditional format dialog after selecting your cell (lets
[quoted text clipped - 25 lines]
>>
>> onlineXmanX@exciteX.com (remove X's for true email)

Reply to this Message