Automatic Conditional Formatting in matrix of information

Hi all

I have been asked to create a clash grid that shows when promotions for specific customers are on for specific products.

I've got all the information collated, and I suck it all up into a cover sheet that splits it by product, by customer, and then shows the weeks each product is on promotion. The issue I have, is I wish to colour code each customer so it is easier to read for those who aren't excel savvy.

I've tried conditionally formatting it, but have stumbled a couple of times. I can write an 'if' statement for it, but can't work out how to get the conditional formatting to follow the statement (I'm not sure this is the best way to do it, but figured it was worth explaining).

Attached is a 'How it is' and 'What I want it to be', so if you could help, that would be great!

Thanks,

StarkeyExample.xlsx

The easy way, you could just define your conditional formatting like this: select you customers using "Ctrl": Conditional Formatting - Highlight Cells Rules - Greater Than... and set your value to 0, and use "Custom Format" - Fill to get to the color you want for those specific cells. I hope it helps.

Hi Cosmina,

I'm afraid I don't follow what you're suggesting. Can you explain the steps a little better?

Thanks.

This has all worked, so thank you very much for your help!