Hello,
In the attached file I have provided an example of what I am trying to
accomplish via macros.
I import a report into excel that changes each time it's ran. I'm trying to
put a space after each 'group' is ran. As an example we have locations set
up as
A-A-0
A-A-1 ect..to A-C-3
B-A-0 to B-F
Using conditional formatting it seems to work like this. Select your range
and then on the conditional formatting menu change to Formula and insert the
below formula, pick how you want it highlighted.
=COUNTIF($A$2:$E$5000,A2:IS2)>1
I'm no expert, but I was able to figure it out. Perhaps one of t
