Excel 2007 : Conditional Formatting

[Chibi]

I am trying to do color conditional formatting for the following scenario:

Column A is a totals column for columns b, c, d, e, f, & g. Each column (b, c, d, e, f, & g) has its own assigned color. I would like column A to reflect the color of whatever column has a value in it and the sum (sum I can do lol). The final caveat is that if there is more than one column with a value it would be a completely separate color.

Thanks in advance for any help!

[dilipandey]

Hi Chibi,

Welcome to the forum.

Would suggest you to upload an excel workbook with sample data.. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

[Chibi]

Hopefully that worked.