Cafe,

Firstly you only need a formula of

=COUNTIF(InputPC,F10)1

as that returns TRUE or FALSE as required by CF.

Then, what is InputPC defined as?

When you setup CF, select F10:AT10 and add the condition formul as above.

--
HTH

Bob Phillips

"cafe" wrote in message
...

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