Thank you. Id like a short vba script, but conditional formatting may also resolve it?!Why do you need VBA?
Can't you just use Conditional Formatting to do it?
=OR(A1="A1",A1="A10",A1="A100")
Thank you JoeA good rule of thumb is to not use VBA to recreate existing built-in functionality (no sense in "re-creating the wheel"), unless there is a good reason to.
It think it should be a simple Conditional Formatting rule, something like:
if I understand you correctly (from the little information you shared with us).Excel Formula:=OR(A1="A1",A1="A10",A1="A100")
If not, please provide more details.
I've had a look at conditional formatting. It does not work - to be fair, I was not very clear in my post....You are welcome.
Glad I was able to help!