Is there a formula for the condition if x>50 color blue, if x>100 colo

[wdegennaro]

Is there a formula for the condition "if x>50" color blue, "if x>100" color red? I want to do a profit/loss chart and I want certain conditions to change color if they meet criteria. Is this possible and if so, how do I word the formula?

 

[bobhc]

I have used conditional formatting Top/Bottom Rules- more rules and then set up the conditions I wanted, worked......I am using excel 2010

 

[Luke M]

CF formula 1:

=A2>100

Format red


CF formula 2:

=A2>50

Format blue


The trick is what order you put the conditions in (as XL reads down until it finds one that works)