Changing Cell Contents Colour
 

Hi there,

I have entered this formula in the past but for the life of me can't
remember how to do it! What i want to do is enter a date in a cell and when
it comes to that date i want it to turn red. Can anyone help with this?

Thanks :)

Changing Cell Contents Colour
 

Format|Conditional formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Spiller" wrote in message ...
| Hi there,
|
| I have entered this formula in the past but for the life of me can't
| remember how to do it! What i want to do is enter a date in a cell and when
| it comes to that date i want it to turn red. Can anyone help with this?
|
| Thanks :)

Changing Cell Contents Colour
 

I rememeber that much - what i don't know is the formula that i have to enter.

Thanks


"Niek Otten" wrote:

Format|Conditional formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Spiller" wrote in message ...
| Hi there,
|
| I have entered this formula in the past but for the life of me can't
| remember how to do it! What i want to do is enter a date in a cell and when
| it comes to that date i want it to turn red. Can anyone help with this?
|
| Thanks :)

Changing Cell Contents Colour
 

In another cell, put =TODAY() (let's say in C3)

In the conditional format dialog, Cell Value is, Greater than or equal to, =C3, and choose your format.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Spiller" wrote in message ...
|I rememeber that much - what i don't know is the formula that i have to enter.
|
| Thanks
|
|
| "Niek Otten" wrote:
|
| Format|Conditional formatting
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Spiller" wrote in message ...
| | Hi there,
| |
| | I have entered this formula in the past but for the life of me can't
| | remember how to do it! What i want to do is enter a date in a cell and when
| | it comes to that date i want it to turn red. Can anyone help with this?
| |
| | Thanks :)
|
|
|