Cond. Format Data Bars of range based on values of another range
One way to do what you want is to duplicate your values in the Names column,
and use a custom format to display Small, Medium or Large. Something like:
[<=10]"Small";[<=20]"Medium";"Large"
Then, because the cells contain numbers, you can use Data Bars for them.
Regards,
Fred
"alexmo" wrote in message
...
I want to format a column titled "Names" using <conditional formatting with
Data Bars based on the values of another columns titled "Values". How
can I
do that?
Ex:
Names Values
Small 10
Medium 20
Large 30
I need the databars to show on the columns Names rather than Values.
--
alexmo
|