I have a bunch of cells that are a myriad of different colors. I basically want to select two colors and everything that isn't one of those two colors needs to be no fill. I wrote something but it's not exactly working. here's what I've got
Please Login or Register to view this content.
Try:
because you want to change colors which are neither rev like nor room likePlease Login or Register to view this content.
Best Regards,
Kaper
I don't quite understand what you're saying. Mind elaborating?Originally Posted by Kaper
Try:
because you want to change colors which are neither rev like nor room likePlease Login or Register to view this content.
IMHO you do wrong trying to test if a<>c1 or a<>c2
because (provided that c1<>c2) if a is equal to either of C1, c2, then is different than second one, so
is always executed.Please Login or Register to view this content.
Makes sense. That worked perfectly. Thanks!
Glad to hear that,
If that takes care of your original question, please mark this thread as SOLVED
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks