How do I change the color of a row on one sheet with a trigger from a second sheet?

davelenard

I'm trying to indicate on Sheet A, when the Primary Key is also found on Sheet B.

I have maxed the size of Sheet A and can't add a column or update the data that could use conditional formatting to make this work.

John_Foster

Hi @davelenard,

If you are unable to add a helper column, I do not think you will be able to do what you want to with conditional formatting. One thing you could do is if you have another helper column, you could merge the to and then use the define custom criteria to read part of a cells value to set the formatting.

Thanks,

John