View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lynora Lynora is offline
external usenet poster
 
Posts: 2
Default Change color of text if date is overdue

I'm trying to create a spreadsheat that will keep track of when our patients
are due for supplies. For example, they can get a certain supply every 6
months. I want the date to turn yellow when we are at the 5 month mark and
red at 6 months
I have a date in cell C2 and have a formula in C3
=C2+180