i know i have to do it in conditional formating but what do i have to write to make cell colour change red when the date has expired???.
Thanks