Formating with If statements

rekaitis

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?

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.

Let me know if it works.