Formatting a cell to populate on a certain date
 

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!

On the 15th of which month? Also, after the 15th do want
this value to be permanent?

In D6 enter this formula:

=IF(TODAY()=DATE(2005,2,15),100,"")

On Feb 15 2005 the cell will populate with the value 100.

Biff

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


.

=IF(DAY(TODAY())=15,100,"")

Vaya con Dios,
Chuck, CABGx3




"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

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

Actually, it's for a budget worksheet, so I need it to occur every month,
but I can adjust you're formula accordingly.
Thanks.
"Biff" wrote in message
...
Hi!

On the 15th of which month? Also, after the 15th do want
this value to be permanent?

In D6 enter this formula:

=IF(TODAY()=DATE(2005,2,15),100,"")

On Feb 15 2005 the cell will populate with the value 100.

Biff

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


.

One way is............

Put =TODAY() in a cell, like F1 or wherever..........
then click on your cell you want to change font color and do Format
Conditional format Formula Is and type =DAY(F!)=15 in the right window,
then Format button then set your color

Vaya con Dios,
Chuck, CABGx3



"fidox" <afsd dal wrote in message
...
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

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