date formatting

[Guest]

I am trying to get the dates in a column of dates to change color when they
become 90 days older then the current date or to change when they already
are. Then, at a glance I could see the dates that are 90 days older then the
current date. I am using =now() as the current date.

 

[Ragdyer]

Select the column of dates, say A1 to A10, then:
<Format> <Conditional Formatting>,
Select "Formula Is" in the first box drop-down,
Enter this formula in the next box:

=A1<NOW()-90

Then click on "Format", and choose a display color to your liking,
Then <OK> <OK>.

 

[camjohnson]

I believe that some 'cell' properties such as font, color, bold, italic
etc. are inherent with the 'cell' format so are not under control b
functions which can be programmed. However, you can do somethin
'similar' by having a separate column next to the original column. Th
second column would be formatted as color red. Then after 90 days yo
could transfer the data from one column (black) to the one next to i
(red). It would then stand out but it wouldn't be the 'same' column.
Similarly you could make a small column which would simply have a re
"X" or "*" in it that would appear after 90 days. That would take les
space and would still be highly visible

 

[Ragdyer]

I forgot to include empty cells, as you discovered in your other post in the
Functions group.

Try this instead:

=AND(A1<NOW()-90,A1<>"")