Forum Discussion
Excel help - Rule and Conditional Formatting
Thank you. Sorry, I was trying my best to explain. So, I have to add another column? There is no way to make the "WF Street Address" just highlight the color to indicate large site? mathetes
Your explanation was perfectly clear. No need to apologize.
There no doubt is a way to do what you asked. Conditional formatting is tricky enough, in my experience, that if I can get anything to work when referring to comparisons between cells (or ranges), I'm happy. I was not able to figure out (and continue to be unable to figure out) how to get the MATCH into the conditional formatting rule itself for the exact column containing the address. Whereas doing it in an adjacent column that contains the MATCH function, it was straightforward.
I'll be delighted to have somebody else show us both how to accomplish exactly what you're asking.