Formating with If statements

rekaitis
rekaitis
in Modeling

I need to format two line items where it is one color when a scenario is true and another when false. There are three different scenarios that can be done:

Line A

Line B

Result

TRUE

FALSE

Line A is yellow Line B is gray

FALSE

TRUE

Line B is yellow Line A is gray

FALSE

FALSE

Both are Yellow

Is a nested If statement a good choice or is there a better way?

Answers

  • SriNitya
    SriNitya

    @rekaitis
    From the condition of formatting it looks like
    True → Yellow
    False → Gray
    In both false case also it should be Gray right. If that is the case then you can achieve this by creating simple if statements in 2 separate line items and apply them as rule in conditional formatting.

    image.png

    Let me know if it works.

Categories