M
Martin Wheeler
xl2000
I want to compare the values in 2 ranges "N1" and "O1:O4". If the value in
N1 is in one of the cells in O1:O4 then I want both cells to light up.
In N1 I have tried = N1 = O1:O4 but have not gotten a result.
Any help would be appreciated.
Ta,
Martin
I want to compare the values in 2 ranges "N1" and "O1:O4". If the value in
N1 is in one of the cells in O1:O4 then I want both cells to light up.
In N1 I have tried = N1 = O1:O4 but have not gotten a result.
Any help would be appreciated.
Ta,
Martin