Microsoft Office Forums - View Single Post - [Solved] Conditonal Format or Formula help please

Thread: [Solved] Conditonal Format or Formula help please

View Single Post

Old

03-04-2013, 01:57 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 7 32bit

Windows 7 32bit Kevin@Radstock uses Office 2010 32bit

Kevin@Radstock uses Office 2010 32bit

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

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

Reply With Quote