View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
 
Posts: 199
Default Conditional Formating - dynamic data bar colors

"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