View Single Post
  #1   Report Post  
Heather via OfficeKB.com
 
Posts: n/a
Default Upcoming expiry date warnings that turn cell contents red

Hi
I have a spreadsheet with people's certificates (eg. CPR) with the date the
cerficiate expires. I want to be able to open the spreadsheet at any time
and have anyone whose certificate is one month from expiring, be red (I want
the whole cell to turn red.) I've tried conditional formatting but can't
seem to get it. Any help would be greately appreciated!!

Thanks:)

Heather

--
Heather