View Single Post
  #5   Report Post  
Kevin@Radstock Kevin@Radstock is offline
Member
 
Posts: 93
Default

Quote:
Originally Posted by Excel Dumbo View Post
Thanks Claus for your valuable time. The formula worked for the first two dates.

There is no "Expired" coming up for 30/09/2013 and it is turning red when it should not. Please refer attached
In B3 and copy down: =(LEFT($A3,2)&"/"&MID($A3,4,2)&"/"&RIGHT($A3,4))+0. This will convert to a number.

In D3 and copy down: =IF(B3<TODAY(),"Expired","")

Conditional Formatting

RED: =AND($B3=TODAY(),$B3<=TODAY()+90)
YELLOW: =AND($B3TODAY()+90,$B3<=TODAY()+365)