Thread: color code a row by expiration date?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default color code a row by expiration date?
Typo correction, sorry. It should be C1 instead of C2.

Lines:
Cond1: =AND($C2TODAY(),$C2-TODAY()<=30,$C2<"")
Cond2: =AND($C2TODAY(),$C2-TODAY()<=60,$C2<"")
Cond3: =AND($C2TODAY(),$C2-TODAY()<=90,$C2<"")

should have read as:
Cond1: =AND($C1TODAY(),$C1-TODAY()<=30,$C1<"")
Cond2: =AND($C1TODAY(),$C1-TODAY()<=60,$C1<"")
Cond3: =AND($C1TODAY(),$C1-TODAY()<=90,$C1<"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote