I am trying to use in conditional formatting the following formula:

=IF(COUNTIF(InputPC,F10)1,TRUE,FALSE) So it will highlight any
duplicates.
But the way i setup the spreadsheet with "Select" as the default is no
working. Any suggestions? or am I doing something wrong. Please it
is urgent!!

The spreadsheet:

in row 10 columns F thru AT, I have a data validation with a list.
The list has "Select "as a default. In column E12 thru E50 I have
accounts:


1001 1002 1003 Select Select
..... etc

Marketing
Admin
'
'
'
etc.

Thank you
Cafe


--
cafe
------------------------------------------------------------------------
cafe's Profile: http://www.excelforum.com/member.php...o&userid=16145
View this thread: http://www.excelforum.com/showthread...hreadid=394458