Conditional Format
In excel sheet first two data rows are document headers(both rows are merged). so my normal data stating form rows 3.
I want to highlight duplicate values in column "A". If bellow text are duplicating that cells should ignore. any other values are repeating in column "A" that all the cells should highlight.. pls give me a formula for conditional format..thanks in advance..
Ignoring Text
LOADINGS :
LOT
Range A5:A1000
Formula
=COUNTIF($A$1:$A$1000,A5)>1
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
thanks but it's not ignoring below cell values..Originally Posted by Fotis1991
LOADINGS :
LOT
What do you mean?
Hi johncena
Try the following formula for the rule in your conditional formatting. Change the range to suit your needs.
Formula:
Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks