Conditional formatting ? numbers match highlight?

[zone709]

Hi I have on one sheet column M to R. If number in these cells match the same numbers from C to G. Then highlight those cells that match from C to G.

So lets example if 5 is in M4 and 5 is then in D5. Highlight D5 any help thanks

 

[zone709]

​ok yeah I screwed up it works now thanks agina

 

[63falcondude]

​ok yeah I screwed up it works now thanks agina

You're welcome. To answer your question, COUNTIF checks a range for a criteria. The range is all of the data in columns M through R and the criteria is C3. Conditional formatting then checks M:R for D3, E3, etc. as well as C4, C5, etc.

A result of 0 is seen as FALSE while a result of anything >=1 is seen as TRUE.

 

[zone709]

You're welcome. To answer your question, COUNTIF checks a range for a criteria. The range is all of the data in columns M through R and the criteria is C3. Conditional formatting then checks M:R for D3, E3, etc. as well as C4, C5, etc.

A result of 0 is seen as FALSE while a result of anything >=1 is seen as TRUE.

Thanks makes sense