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.

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...


<(E-Mail Removed)> wrote in message
news:bccc7c58-930a-468a-8c79-(E-Mail Removed)...
>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.