Format rule if value in column A is higher than column B

[Ron1]

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.

[WillowMobileSys]

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

1. Select the column or columns you would like to be formatted - Total Column
2. Set Text color = red
3. Set Text Format Bold switch turned on.

i hope this helps!

[Ron1]

WillowMobileSystems:

[Column A] > [Column B]

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.