Conditonal Format or Formula help please

pabyford · #1 03-03-2013, 02:03 PM

I have several pick lists that I need to apply some error checking to and was thinking of using conditional formatting.

I have 15 dropdowns that draw from a list of names. I need to format the cell background colour if that name exists in any of the other 14 dropdowns.

Suggestions and examples greatly appreciated.

Cheers

Kevin@Radstock · #2 03-04-2013, 01:57 AM

Hi pabyford

Try the COUNTIF function for the conditional formatting. For example and assuming the data validation are in A1:K1.

=COUNTIF($A$1:$K$1,A$1)>1

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula help	excelledsoftware	Excel	8	03-25-2012 08:49 AM
Formula help	furface00	Excel	10	02-26-2012 05:34 AM
Formula Help - Look and if and that	Corca	Excel	2	02-05-2012 09:18 AM
Need help with a formula	tinkertron	Excel	11	04-16-2009 11:43 PM
Date format always interpreted as a formula	Butch Jackman	Excel	1	02-14-2006 11:27 AM