Try this for a start (untested by me!)

Assume data is in columns A to G

Select column A ...

in CF:

1st Condition ..find values unique to column A ONLY i.e there is only one
occurrence in the 7 columns

Formula is: =AND(COUNTIF(A:A,A1)=1,COUNTIF(A:G,A1=1))

Set formatting .... GREEN

2nd Condition ..find values unique to column A but which occur in other
columns i.e. value is column A once but also in columns B:G

Formula is: =AND(COUNTIF(A:A,A1)=1,COUNTIF(A:G,A11))

Set formatting ... YELLOW

If this works, repeat for other columns change references to A to B,C etc.

This could get rather messy and not easy to interpret but comparing 7
columns is unusual.

HTH

"teejay" wrote:


Can you please give some didactic instructions. I am not really good at
excel.

I checked conditional formatting option but couldn't find countif
option in any drop down menu!!!


--
teejay
------------------------------------------------------------------------
teejay's Profile: http://www.excelforum.com/member.php...o&userid=37009
View this thread: http://www.excelforum.com/showthread...hreadid=567322