Hi,

I need to use conditional formatting in an excel spreadsheet, but there are
four variables:

between 5% : 10% = amber colour
greater than 10% = red colour

between -5% : -10% = amber colour
less than -10% = red colour

Using conditional formatting I can only use 3 variables. Is there a way I
can do this?

Thanks
Amanda