change color of columns depending on value

[van Velzen]

 

[Frank Kabel]

Hi
use 'Format - Conditional Format' for this. See:
http://www.contextures.com/xlCondFormat01.html

 

[Andy Pope]

And just in case you meant chart columns have a look at
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Frank's so prolific he may have missed the NG you posted in <vbg>

Cheers
Andy

 

[Frank Kabel]

Hi Andy
lol
you're right. Thought this was the .misc group )