How to recreate conditional formatting using VBA
Hi all,
I've searched all over the net for this one since I thought it would be a popular question, but unfortunately couldn't find a solution.
Would anyone know how to (using VBA only) perform a VBA "conditional format" so that every cell in col R, that contains the word "YES" will have a green background?
...ps: This needs to be done via VBA only since I need to run the code from a personal.xlsb file.
Thanks so much,
JMC
Hi,
One way, and I presume you don't want literally all the 1 million+ rows to be subjected to this, in which case edit the R:R range as necessary
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Re: How to recreate conditional formatting using VBA
Thanks so much, Richard!
ps: After noticing that it worked only after the 2nd run, I realized I needed to copy the last "AutoFilter" line to the beginning to get it to work properly in Excel 2007. With that small tweak, this worked perfectly! Thanks again, Richard! -jmc
Please Login or Register to view this content.
Last edited by jmccoughlin; 11-02-2015 at 11:16 PM.
i think you already figured it out but when using autofilter
to ensure it is correctly working
turn it off autofilter first then apply filter new filter
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks also, humdingaling! This looks like an even cleaner approach to take care of that issue, and will also use that suggestion as well! -jmc
Originally Posted by jmccoughlin
Yes, good catch and well spotted. Mea culpa
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks