Hi all
I have got my head around formatting rules to some extent, but for the purpose of an alert if inventory goes below a certain value I was wondering how I would type the condition if one column level is higher than the other that the total would be red and bold.
Each Format Rule is evaluated against each row, so the expression you would would be simply:
[Column A] > [Column B]
Place this in the “If this condition is true” area of the rule.
Then
i hope this helps!
Thank you John, it didn’t work at first but then I realised I had one column as a text instead of a number. But it’s good now.
User | Count |
---|---|
44 | |
34 | |
24 | |
23 | |
15 |