Conditional Formatting

[clylab]

I already have conditional formatting in a cell so that if the cell value is less than a certain number the cell appears RED. The cell containa formula which is linked to other cells. I also want to add another condition which makes the cell appear a different colour should the value in another cell be greater than 0. For example: Cell A1 contains a formula and the conditional formatting means if the value is less than 100 the cell goes RED. If cell B1 contains a figure greater than 0 I want cell A1 to be a different colout, irrespective of it value, I want the 2nd condition ot take priority. How can I do this?

[teylyn]

Hi clylab,

welcome to the forum.

The key to this is the order of the conditions in the Conditional Formatting dialog.

The first condition for A1 should be Formula Is
=$B1>0

the second condition should be
=$A1<100

Excel will evaluate B1 first, and if that condition is met, apply the format you set for it and exit the evaluation. Only if the condition is not true, will Excel evaluate the second condition.

This way, the B1 evaluation will always take precedence

hope that helps