Can a cell change colors when the date entered arrives?

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

Guest

I'm wondering if there is a way to format a cell so it changes colors when
the date entered arrives
 
I think you could use 'Format'....'Conditional formatting' and enter a
formula as the condition which would check to see if the date in the cell
equala =TODAY()
 
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

How do I stop Excel from copying date format from cell above? 2
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formats Date Based 1
Excel 2007 Problem Paste/Enter Key 0
Change Color of cell 3
Excel 2000 Validation with colors 1
Change the color of a cell 7
Using Dates with the IF function 2

Back
Top