Anther formatting question. I currently have a rule to colour in a particular cell, if comments are entered in another cell.
Is it possible to set an exception should the letter 'Q' appear anywhere, be it upper or lower case?
Current code:
So it would be the =SEARCH("""",$W2)>0 that needs modifying I would imagine with an "unless q" argument in there?
Please Login or Register to view this content.
Not mega urgent, but would be nice if I could include this in! Thanks all.
Last edited by Graham Pall; 07-22-2015 at 09:09 AM.
Still learning... one day I will be able to help!
Hello
I've not tried this with VBA but perhaps if you change your SEARCH function in the code to:
Formula:
Please Login or Register to view this content.
SEARCH is not case sensitive so it will catch either upper or lower case Q's.
DBY
Thanks DBY. I've put that into the macro, but it didn't like it
Compile Error
Expected: end of statement.
VBA Editor is highlighting the 'Q' on it's own.
Hello Graham
In VBA the Q has to be enclosed in double double quotes ""Q"". The following seems to work for me:
Please Login or Register to view this content.
Last edited by DBY; 07-22-2015 at 01:06 PM.
Worked a treat! Many thanks. Rep added.
Glad to have helped. Thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks