| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 :) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 :) | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
