Conditional formatting if values match

[pbyrne462]

Hi everyone,

I have two tables one is my input table containing:

A1: Product
B1: Country
C1: Quarter

with the values gonig down the page. I then have an output table that has the quarters horizontally, 1-4 and the corresponding countries stacked above each quarter. All my marcos and formula are fine for that part.

i also need to change the formatting in my output table depending on the product (each product has its own colour). My thought was to have some conditional formatting that compares B1 and C1 of my input table to the output table, then if they match to turn the cell the colour required depending on the Product A1.

I hope this makes sense and help is very much appreciated.

Paul

 

[pbyrne462]

To clarify I need to find a way of saying this in a formula in conditional formatting.

if A1+A2 = B1+B2 and A3= Product1 then turn the cell green.

Any ideas????