View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lee
 
Posts: n/a
Default Changing colors?

I have a worksheet that has a list of medication in column A with their
corrisponding expiration dates in column B. How can I make the dates in
column B change to red when the current days date is within 60 days of the
expiration date shown? Will it do this?
--
Lee Davenport