Change cell color based on value of another field

[#1]

Hello,

This is a bit simplified from the actual scenario, but should illustrate the need. Let's say I have three fields, Appr1, Appr2, and Appr3. I want to be able to highlight in red, any of the three that agrees with any other one. In other words if Appr1 and Appr2 are the same, I want both to be highlighted.

I'm thinking if there's a function I can use within the expression itself, I could make that happen, but I'm not aware of any such function. Or maybe another approach altogether?

Thanks,
Dino

[Anonymous · Accepted solution]

Dino,
Assuming you're speaking about a table - you can use attribute expressions. notice the+sign at the expression name in properties, expressions. Create attribute expression for the background color or text color:
if(Appr1=Appr2, rgb(255,0,0))

[#3]

Wow! You don't know how many times I've accidentally opened up that (+) and thought "I dont need any of these." Now I understand...

Thanks,
Dino