Hi.
I have this macro below that creates 2 different conditional formats. The problem is that the second conditional format is not displaying the color the code instructed it to.
Here is the workbook I am working with Conditional Formatting.xlsm
And here is the code that sets two different conditional formats
Any help would be greatly appreciated.
Please Login or Register to view this content.
What color is it supposed to display?
You reset the color to condition1 try:
Please Login or Register to view this content.
Last edited by Solus Rankin; 03-27-2014 at 05:20 PM.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Green.
It really doesn't matter because i'm trying to test everything out. You can put whatever colour you want.
The problem is that the color is being returned as blank. Also the CF shows that no format is set even though the code set it.
I edited my first post. Try that.
Wow! It worked!
I see what you did...you identified the 2nd condition as condition #2.
I feel a bit sheepish
Thank you
You can actually do it with a single with block and without activate. Maybe:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks