View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m tim m is offline
external usenet poster
 
Posts: 430
Default Can a cell change 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()

"Peadink" wrote:

I'm wondering if there is a way to format a cell so it changes colors when
the date entered arrives