Forum Discussion
Psugirle
Jul 28, 2020Copper Contributor
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...
TheAntony
Jul 29, 2020Iron Contributor
Psugirle , Let me know if this works for you. I used the new XLOOKUP function. If you don't have XLOOKUP, it can work with other lookup functions.
Basically CF needs a TRUE or a FALSE so I always play around with the formulas on the worksheet and then paste into the CF dialog when everything works. I left the calculations on the second sheet for you to review and change as you see fit.
mathetes
Jul 29, 2020Gold Contributor
Well done!
And I like this: Basically CF needs a TRUE or a FALSE so I always play around with the formulas on the worksheet and then paste into the CF dialog when everything works.
It's next to impossible to do that playing around (especially for a situation like this one) IN the CF dialog box itself. So, again, well done!