View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dennisthe10 dennisthe10 is offline
external usenet poster
 
Posts: 3
Default Conditional Format help

Hi
I have a date in H4 where using conditional formatting, will flag green if
its within 2 days of today, amber if 2-3 days of today and red if 3+ days
from today however, i need the formatting to stop if there has been a date
entered into I4 (as this will mean there is no need for the cell to flag to
us that there is no data in I4 if that makes sense)

can anyone help please?

thanks

Dennis