Thread: Conditional format color is set correct, yet color will not change
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
milo milo is offline
external usenet poster
  
Posts: 22
Default Conditional format color is set correct, yet color will not change
Sorry again!
I hope this should help

Condition1: (For Red)
=AND(ISNUMBER(A1),DAY(A1)<=14)

Condition2: (For Green)
=AND(ISNUMBER(A1),DAY(A1)=15)

Regards,
Reply With QuoteReply With Quote