I have 2 sheets one is a data set (Sheet1) and the other is a list of building names (Sheet2). The range of cells can vary in size for both sheets as these are reports that are generated and change from day to day. What I am trying to do is if a value from Sheet2 shows up in the dataset sheet1 I would like the color to change on SHEET2 to Red. Conversely, IF a building name does not show up on sheet1 then the color on sheet2 for that building name needs to change to green. I have tried Conditional formatting using this function
=iSERROR(VLOOKUP(A1,Sheet2!$A:$A, 1, 0)) = False color changes to green But this does not work it changes everything green
I need the values on sheet2 starting from A2 down to a variable range
and I need the values being compared from sheet2 to sheet1 to be a variable range on sheet one as this range could increase or decrease from time to time.
=iSERROR(VLOOKUP(A1,Sheet2!$A:$A, 1, 0)) = False color changes to green But this does not work it changes everything green
I need the values on sheet2 starting from A2 down to a variable range
and I need the values being compared from sheet2 to sheet1 to be a variable range on sheet one as this range could increase or decrease from time to time.