Conditional Formatting: Data Bar, change gradient color based oncondition?

[velasquez.m]

I have a worksheet where I'm using single cell conditional formatting
based on a range given 2 specific values.
So the conditional formatting range is not based on a range of other
cells, it's 2 hard-coded values.

I'm using a data-bar conditional formatting style.
The data-bar serves as a warning indicator if a value falls below a
certain number.
In my implementation the gradiant displays a yellow bar if the value
of a cell is greater than 60% but less than 80%.
Over 80% it does not display the data-bar.

My question is this:
I would like the data-bar to change to RED if the value falls below
60%.

In my yellow data-bar conditional formatting rule I have it set so
that the shortest bar is linked a certain cell by way of formula as
well as the longest bar linked to another cell.

I also have the "default format" rule set to if the value goes above
80% so that it will not display the data-bar at all.

How can I set a 3rd rule to allow for either:

a) the gradient of the data-bar to change to red
b) a new red data-bar displays and the yellow data-bar is hidden

Thank you in advance.

 

[MDBJ]

I don't get all the problem.
but excel calculates conditional formatting based on the first result that
matches- use that format.

so I have a colored page- where EVERYTHING is green (for good)
then it has conditional format, make red it less than 75%
make yellow if less than 90%
make black if more than 110%

if my figure is 74 as soon as it hits the first format-- true- less than 75-
it ignores the balance of the conditional formats...

so it doesn't go to yellow- even though the data is below 75 and 90%
both--it is already matched.

-- it's possible the reason you aren't getting your red-- is that it's
matching on yellow already and no longer considering later format states...