Search results

..just by way of sharing the solution here this is what I ended up using - a variant of the code supplied by Deb for which - huge thanks Sub RepeatingValues() Dim usedcell As Range ActiveSheet.UsedRange.Cells.Interior.Color = vbWhite For Each usedcell In ActiveSheet.UsedRange currentcolor =...

Deb - that is FANTASTIC - many MANY thanks - I think I can adapt your code to do exactly what I need. Really - so grateful!

haha - yes, I may be a little over-exaggerating when I say HUNDREDS - but there are a large number. I guess my point is more - how can one achieve this efficiently rather than coding for specific instances of repeated items - thanks all

yes - this works but I need to specify each individual repeating value as a separate conditional formatting formula - if there are many hundreds of these and they change from period to period it's not terribly efficient. Trying to think how I can have one conditional format that searches the...

yes - am very open to VBA solution too - thanks

thanks - yes - this works when you have a distinct set of repeated values - what I'm looking for is something a little more generic - say for example there are many hundreds of different, duplicated items - how would one create a formula or conditional format that looks to see whether the item...

Hi all - I am a newbie in terms of posting a question but have been following the forums avidly for some time. My question is this: In my spreadhseet there are columns of names - many of which are repeated accross the columns. How can I highlight each common item in the same color? For example...