fidox wrote:
I have a similar problem, except that I already have the value in the cell,
I just need the font color to change for that date on. How would I
accomplish this?
Thanks.
"Brian" wrote in message
...
I want to have a cell populate with a specific value once a particular date
coemes.
Example: On the 15th of the month I want to have cell D6 populate with
the value 100.
THanks
Hi Fidex
Try the following
Conditionally format the cells in question to alter colour subject to;-
=$A$1=TODAY()
|