Tom - 12458.html
Posted by Chris D on January 02, 2002 12:23 PM
12293.htmlfinding duplicates via conditional formatting
Tom, sorry, this very probably illustrates what you meant by "user error" etc etc !! and how VBA is quicker and easier once written. I'm ploughing through a JWalk VBA book so am about to launch into VBA coding soon as I agree with you about automation and letting excel do the work for you...
With my conditional format option, I took my example (produced at home over Xmas) and pasted it from this bulletin board into a sheet at work, and as you pointed out, it didn't work !
Tonight, I pasted again from this bulletin board, from my own message, and it didn't work !
In the space for the formula that precedes "formula is", when I pasted, it automatically inserted "quotation marks" around the formula
(ie - "this is the formula" rather than just this is the formula)
and the conditional format failed. When I deleted these "quotation marks" the conditional formatting worked fine, all the duplicates adhered to the specified formatting [a nice shade of purple background]
I guess my question is : what is the significance of these "quotation marks" within the formula in the ~formula is~ section of conditional formatting ?
many, MANY thanks if you find the time to address this, I look forward to taking that step into VBA via JWalk, but am resigned to logical functions for the moment !