Forum Discussion
Excel help - Rule and Conditional Formatting
I have a basic excel workbook with two sheets. Sheet “A” which is tracking all my “cases.” This includes names, phone numbers and addresses. On sheet “B,” titled “larger sites” I have 40 specific addr...
Psugirle , something like the attached? Used the below formula in the conditional formatting rule.
=COUNTIFS('All Cases'!$H$2:$H$31,H2)
- Thanks. I will attempt tomorrow and will let you know. 🙂 Does it matter if on Sheet “A” the address is in column H, but on sheet “B” all the addresses I want to compare too are in column “A?” Also, I have 40 addresses and I listed them individually on each row vertically. Will that change the formula you provided?
