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