View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David G. David G. is offline
external usenet poster
 
Posts: 12
Default Conditional Formatting

Hi! How can I conditionally format a range of cells so that they change
depending on today's date? For example, I want cells B1 and CI to have a
different color today; tomorrow, the color will return to normal for those
cells but change for B2 & C2, and son on. Data in columns B & C will have
numbers, not dates. Can this be done?

Thank you.

A B C

1 12/15 1500 1200

2 12/16

3 12/17