I need a conditional formatting formula that will allow this to happen.
if J4 sheet1 =/=(not equal) H3 sheet2 then highlight yellow
if J5 sheet1 =/=(not equal) H4 sheet2 then highlight yellow
if J6 sheet1 =/=(not equal) H5 sheet2 then highlight yellow
if J7 sheet1 =/=(not equal) H6 sheet2 then highlight yellow
........ 20-30 rows
I can do it one at a time but that is going to take forever.
Capture.JPG
I need a formula which will apply to all rows in column J sheet one and column H sheet two.
Help please.
Bookmarks