Data bar conditional formatting based on another cell

V

Vivek

I'm using Excel 2007 and have my setup as below:

Column A contains list of names
Column K contains percentage gains for the names in column A.
The percentages vary between -100% and +100%

I want to apply conditional formatting as below:
Have a 'data bar' in column A with GREEN color if
the corresponding value in K is positive.
Have a 'data bar' in column A with RED color if
the corresponding value in K is negative.

There is another sheet where column K contains numbers
instead of percentages. I would like to format column A
in the same way here as well.

Thanks,
Vivek
 
S

Shane Devenshire

Hi,

You can use data bars in this way - that is both to do a bar proportional to
the value and work with positive and negative values. You can create to
gradient fill formula rules but the bars won't be proportional to the values.

I have an additional idea, but I need to go to work now so I'll get back to
you if I have any success.
 
V

Vivek

Hi Luke,

It's odd that the data bars are not designed
to tell negative values apart from positive ones.
Looks like I will have to wait for the next
version for this simple feature - typical MS stuff.

Thanks,
Vivek
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top