hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
Hi all,
Looking for a piece of code that does the following.
If any cell in range V4:V37 is selected, and the cell colour is orange, then a message box pops up.
Searching found me a few potential results, but the issue seems to lie in the fact that the orange is a Conditional Format rule. I can write a piece that says if cell selected then msg box, but its the only if its orange part that im stuck on.
Any suggestions?
Looking for a piece of code that does the following.
If any cell in range V4:V37 is selected, and the cell colour is orange, then a message box pops up.
Searching found me a few potential results, but the issue seems to lie in the fact that the orange is a Conditional Format rule. I can write a piece that says if cell selected then msg box, but its the only if its orange part that im stuck on.
Any suggestions?