multiple conditional formatting

[penfold1992]

my current code is:

Please Login or Register  to view this content.

however this doesnt seem to do what i want it to do...
i wish for all values less then 0 to be in red and all values more then 7 to be in orange.
as they dont conflict i shouldnt have to set priority.

however what actually happens is i get the "less then 0" condition to be orange and the more than 7 condition is just normal formatting... how can i fix this?

EDIT: i was missing the line

Please Login or Register  to view this content.

however this now makes my header orange... is there any way to prevent that without setting a range like "H2:J30000"
as my data size could increase i would like to be able to add to the data without having to re-highlight or increase the range of the formatting.

[mshale]

Best way to do it using your existing code is to clear the formatting conditions from the headers:

Please Login or Register  to view this content.