Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-04-2013, 01:57 AM
Kevin@Radstock Kevin@Radstock is offline Conditonal Format or Formula help please Windows 7 32bit Conditonal Format or Formula help please 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditonal Format or Formula help please 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
Conditonal Format or Formula help please 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft