Data bar conditional formatting based on another cell
 

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

Data bar conditional formatting based on another cell
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Vivek" wrote:

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

Data bar conditional formatting based on another cell
 

I think Shane meant "can't" use data bars. ;-)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Vivek" wrote:

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

Data bar conditional formatting based on another cell
 

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

"Luke M" wrote in message ...
I think Shane meant "can't" use data bars. ;-)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Vivek" wrote:

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