Conditional Formatting

[Gos-C]

Hi Everyone,

I highlighted cells H3:S1002 and entere
*=AND(C3<>"",ISNUMBER(MATCH(C3&D3&E3,$C1:C2&$D$12&$E1:E2,0)))* fo
Conditional Formatting but only the cell in Column H (instead of al
the cells in Columns H to S) is formatted where C, D and E match. I
my formual incorrect? If so, can someone give me the correct formula.

Thanks,
Gos-

 

[HS Hartkamp]

Could it be that you'd want absolute references in the formula ? (i.e. put
some $ in there?) You can check that by selecting some cell in column S and
looking at what conditional formatting that cell has got.

Bas Hartkamp.

 

[Herbert Seidenberg]

Assuming you meant $D1 instead of $D$1
Try
=NOT(((C3&D3&E3)<>($C1&$D1&$E1))*((C2&D2&E2)<>($C1&$D1&$E1)))*(C3<>"")