i'm not quite sure i follow that... can you elaborate?


"Victor Delta" wrote:

"Sirpent0r" wrote in message
...
Thanks Chip,

Yea i could not see a way to do this either. I was wondering if there were
a
way to apply a formula that could manipulate the data bar properties, such
as
a "If / Then" type statement.

If cell value = 1,2, or 3, then data bar gradient = Red
If cell value = 4, 5, or 6, then data bar gradient = Yellow

something like that?

Why not make the data bar out of 10 separate cells? Then it could be done...

V