You can add multiple conditional formats. Click the add button on the
conditional format dialogue box to get space for a second condition. Set
first condition to check if E58=100 (set format to red). Set second
condition to check if e58=90 (set format to yellow). Conditional formatting
only gets to the second condition if the first one isn't true, so E58=101
won't make it yellow as the first condition is already TRUE and formatting is
red. No need to set a condition for E58<90 as this will be the net result of
the first two both being FALSE.

Cheers,

Glen

"AndyB" wrote:

Data is input in to cell E57.
A percentage is calculated, based on the input and returned to cell E58.

I used CF to compare this with cell E29
=$E$58$E$29
If the result is above that of E29, E58 turns red.

What I want to do is turn E58 yellow if the result is up to 10 below E29.

What I mean is if cell E29 = 100
E58 100 turn red
E58 is 90 to 99 turn yellow
E58 < 90 no format