Hi
this would require VBA. You may try if 'Format - Conditional Format' is
sufficient for you

"suzi" wrote:

How do I set it up so that if I enter text into a cell a colour then fills
the cell to highlight it? I would also like the colour to go back to white
after a set period, say 48hrs, can this be done?