Forum Discussion

HRGuru55's avatar
HRGuru55
Copper Contributor
Jun 18, 2021
Solved

Conditional Formatting...yet another problem I can't solve

not sure if it is the order of the rules, the use or non use of the "stop if true" or what... but the formatting is not working the way i need it to.  In the attached screenshot, I have highlighted that 2 rows are not showing the "blue" formatting the way it appears in the other rows... additionally the "green" formatting is not appearing at all... but if i change the order of the rules, the "green" formatting appears and some of the "blue" disappears

  • HRGuru55 

    Rule formula in addition to other conditions checks if the day (R1) is less than Actual End (P3). For the mentioned rows Actual End is blank, which is converting to zero using in formula. Thus that always returns FALSE, thus no colors.

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    HRGuru55 

    Conditional formatting checks rules one by one top to down. If it finds rule which triggers the formatting, it ignores the rest of the rules.

    Your Blue rule has subset of conditions which Green rule has. Thus if Blue is before Green the latest never be checked.

    Please check in attached.

    • HRGuru55's avatar
      HRGuru55
      Copper Contributor
      Any suggestions as to why formatting is not working in rows 5 & 8
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        HRGuru55 

        Rule formula in addition to other conditions checks if the day (R1) is less than Actual End (P3). For the mentioned rows Actual End is blank, which is converting to zero using in formula. Thus that always returns FALSE, thus no colors.

Resources