Colour paired numbers and highlight unmatched numbers

[tek9step]

Hello

I am looking for a vba help where by it could highlight Green if one number found more than once in Column A and highlight Red those which are not paired on the Data sheet. I have highlighted in my example sheet the result expected.

Thank you

regards

[JBeaucaire]

Use conditional formatting.

1) Highlight the data and color it green, that will be the default color
2) Apply a conditional formatting formula of:
Condition1: Formula Is: =COUNTIF(A:A, A2)=1
Format... Patterns > Red

[tek9step]

Hi JB " Always a life saver "

I tried this but some how not sure why the result is not coming with a extrapolated example. It seems to be picking one figure above the non paired number.. ?? I have uploaded the example.

regards

[JBeaucaire]

Hehe...your sample data started at row2, so that was the row the base formula was for. You should change A2 to A1 if you're going to apply it from row 1.

Also, applying CF to an entire column can really come back to bite you later. Files with formatting applied wholescale like that often start to mysteriously bloat into MBs and MBs of size with no data at all in them.

I'd apply the CF to the range you need and perhaps a "little" more.

[tek9step]

Silly me !!!! Thanks JB no wonder i keep havin to delete stuff of my memory stick... JB change your office to 2007 it seems to compress files compared to 2003 wen savin hehe,,..

regards

[JBeaucaire]

...JB change your office to 2007 ...

Oh...shudder the thought.