Question about condition formatting?

[Guntars]

This is what I would like to achieve. From the moment when I enter a data in
cell I would like that text to stay red for number of days, and after that
period of time text would return to its default formatting which is text
color black. In short, can I condition format cells for period of time, and
after that period of time cell would lose the formatting?

Thank you
Guntars

 

[JBeaucaire]

The only way Excel will know the DAY you made an entry in a cell is if there
is an additional cell with a date stamp in it. No other way, really.

You can use a worksheet_change event macro to watch your particular column
and every time you make an entry in that column, Excel secretly adds a time
stamp in an adjacent cell. The column for that cell could be hidden if you
wish.

Once that date is on the sheet somewhere, then simple conditional formatting
could handle the "stay red for 7 days" kind of thing.

For instance, the date stamp is hidden in H2, and G2 is your data and the
following conditional format:

Condition1: Formula Is: =TODAY()<(H2+7)
....format pattern color as red.

Does this help?