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)

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)
>
>

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)
>>
>>
>