Automatically insert fill colour when data is added?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
this would require VBA. You may try if 'Format - Conditional Format' is
sufficient for you
 
You could set the conditional formating

Format!conditional format
drop down box from "value" is to "formula is"
=NOT(ISBLANK(A1)) assuming your range starts in a1

As to your 48 hour removal of this format, it could be done if you
maintained a date on the entry of the cell, but excel doesn't automatically
manage that.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically insert fill colours? 1
Automatically add fill colour when data is entered 1
how to update certain text in a cell according to thecell colour 1
Change the colour 1
Excel Conditional Formatting Removal 7
Formula for Dates and CF Colour then convert to Text 3
excel 2003 - formatting cells - colour 1
automatically fill a cell in excel by pressing a key 4

Back
Top