View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VSS VSS is offline
external usenet poster
 
Posts: 2
Default Conditional Format to display text alert

I have a column of dates that are expiry dates of professional trainings. I
want the cells in the same column to display "Good" if the expiry is more
than 120 days away and "Book" when it is 120 or less days away. Would help if
the "Book" appeared in red. Please help.

Thanks in advance.