Shoutbox

Well it is possible using your own rules under Conditional Formatting.
The only way I know how to do it requires an awful lot of work and only works if you have standard values in the B column...

see http://www.cpearson.com/excel/banding.aspx for related info about colouring a row...