conditional format: show red if lower than 2 variables depending on value of another field

[chriscools]

Hello,

i want to have conditional formatting for calculated values.

i don't think i can do it with visual cues, because it depends of the value in another field.

there is a field "LegalEntity", and if the value for LegalEntity is "1" then the calculated value should show in red

if it is lower than "variable1".

If the LegalEntity is "2", then the calculated value should be in red whenever it is lower than "variable2".

Is this possible and how should i do it?

is it also with visual cues or is there another way?

grtz

Chris

[sunny_talwar · Accepted solution]

Use a background color expression like this may be:

If(LegalEntity = 1,

If(Expression < variable1, Red(), AnotherColor),

If(LegalEntity = 2,

If(Expression < variable2, Red(), AnotherColor))

[ramoncova06]

expand the expression and the select background color

then go to definition and enter whatever formula you want to use

[chriscools]

thanx, this was perfect!!!

grtz,

chris