change color of columns depending on value

Frank Kabel · Oct 7, 2004

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

Andy Pope · Oct 7, 2004

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 · Oct 7, 2004

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

)