[Solved] Change sheet2 column A red if the text appears in sheet1 column A

[bino1121]

looking for a formula or conditional formatting so that if the text building1 shows up on sheet1 then the value on sheet2 that is building1 changes red

conversely, if the text on sheet1 does not show up in the column A on sheet2 (building1 is not on sheet1 but is on sheet2) then the color changes to green.

Example 1A&B

Example 2A&B

 

[Nujat Tasnim]

Hello bino1121,

It's great to hear from you on our platform. I have found solutions to both your problems after exploring the attached Workbook.

In your first problem, you want to apply conditional formatting if a value on Ex1A is present on EX1B and then change that value on EX1B in RED. You can use the below formula to perform your task.

=ISNUMBER(MATCH(A1,Ex1A!$A:$A,0))

And in second one, you want to apply conditional formatting if value on EX2B is not present on EX2A and want to change color of those cells on EX2B in GREEN. Here is the formula that will do your task perfectly.

=ISNA(MATCH(A1, EX2A!$A$1:$A$3, 0))
I have attached the .xlsx for your clear understanding. Feel free to contact us again with any other inquiries or concerns.

Regards
Nujat Tasnim