Thread
:
Formatting a cell to populate on a certain date
View Single Post
#
6
CLR
Posts: n/a
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
Reply With Quote