Format rules 2 field

sorry trivial question, I’m using FORMAT RULES, I created one that if a value is not empty color me the line purple.
Still on the same line of data I would like that even if a second field is not empty it will color me all green.

0 1 61
1 REPLY 1

If you are trying to have multiple conditions to your format rules you can try using the IF() function in your app. So for your second rule you could say IF(second field is not empty, True, False) Then stack your format rules in the order you want them to be checked in. I hope this helps some, if not please feel free to respond especially with pictures and I can try to help you out a bit more.

Craig
QREW Technologies

IF()

Top Labels in this Space