Quote:
Originally Posted by Pecoflyer
You're welcome. I've seen many folks having problems with the AND function. Always easiest to check a function's syntax first.
|
Yes, and no doubt the problem was syntax. Because the "and" was there, but it was not in the right place. I tried putting it in various ways and it did not work at all.

It's solved and I'm already applying on multiple worksheets.
Thank you for your help.