Changing Cell Contents Colour

S

Spiller

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

Niek Otten

Format|Conditional formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

Spiller

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

Thanks
 
N

Niek Otten

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

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