#1 IF =EXPIRED-->RED

#2 IF >= 0YEARS,6MONTHS,0DAYS-->GREEN

#3 IF<0YEARS,6MONTHS,0DAYS-->YELLOW

Rule #1 works as designed. Rule #3 is not sorting by date as it should. By rule, any date over 6 months should be colored GREEN. However, anything with 10 and 11 months is wrongly colored YELLOW for some reason. I have altered the order of rules but with same effect.

Anyone have any ideas as to why this formatting problem exist and how to correct it?

Thanks,

L.M.

Staff Certifications2.xls | ||||||
---|---|---|---|---|---|---|

J | K | L | M | |||

10 | TIMEUNTILRENEWAL(YEARS/MONTHS/DAYS) | |||||

11 | EXPIRED | |||||

12 | EXPIRED | RULE#1 | ||||

13 | EXPIRED | |||||

14 | EXPIRED | |||||

15 | EXPIRED | |||||

16 | EXPIRED | |||||

17 | EXPIRED | |||||

18 | EXPIRED | |||||

19 | EXPIRED | |||||

20 | EXPIRED | |||||

21 | EXPIRED | |||||

22 | 2years,0months,0days | |||||

23 | 1years,8months,21days | |||||

24 | 1years,8months,21days | |||||

25 | 1years,8months,21days | |||||

26 | 1years,8months,21days | RULE#2 | ||||

27 | 1years,6months,21days | |||||

28 | 1years,6months,21days | |||||

29 | 1years,6months,21days | |||||

30 | 0years,6months,21days | |||||

31 | 0years,6months,21days | |||||

32 | 0years,6months,21days | |||||

33 | 1years,0months,0days | |||||

34 | 0years,5months,20days | RULE#3ERRORS | ||||

35 | 0years,5months,20days | |||||

36 | 0years,11months,21days | |||||

37 | 0years,11months,21days | |||||

38 | 0years,11months,21days | |||||

39 | 0years,10months,20days | |||||

CCRN |