Solved I need to highlight cells that are triplicated

August 16, 2012 at 04:08:16
Specs: Windows 7
In Excel I need to highlight triplicte text in a selection of cells, but I only want to highlight the triplicated text not the first two entries
Using office 2010.

See More: I need to highlight cells that are triplicated

Report •


#1
August 16, 2012 at 10:04:46
✔ Best Answer
Triplicated...now that's a cool word!

Let's say your data is in A1:A whatever.

Select the entire range and use this Conditional Formatting Rule:

=COUNTIF($A$1:$A1,A1)=3

Notice where I used the $ and where I didn't. You need to let the last row in the range update itself for each cell, which CF will do for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question