Forum Discussion
Excel help - Rule and Conditional Formatting
I don't think that worked, or I just might not be doing it correctly. Here is my actual spreadsheet. I am looking for the rule that if any of the addresses listed on "larger sites" sheet is inputted on "sheet1" in column "G" that the row would change a different color so it would alert me.Psugirle
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.
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!
