Hi

I have a spreadsheet that looks like that
Col A Col B Col C Col D Col E
brand A xxx xxx xxx xxx
brand B xxx xxx xxx xxx
band C xxx xxx xxx xxx

i used conditional formatting to automatically color brand A as red and
brand B as blue. The conditional formatting seems to able to color Col A. Is
it possible to extend the coloring from Col A to Col E, always referencing to
Col A. If not, any other alternatives.

Thank you in advance for your help.