I have two sheets in the same file where "sheet1" has cleaned up information and "sheet2" has the dump from my jira. Now I am trying to compare Column F from sheet1 and sheet2 to confirm if they are the same or different. If different I need to mark that particular cell in sheet1 as GREEN. I have tried following custom formula under conditional formatting
=("sheet1!F") <> INDIRECT("sheet2!F")
But some reason I am not sure it does not mark the respective cell as GREEN. Under conditional formatting, I am selecting cell range as F1:F1000.
Above formula should be applied to all rows in Column F even though some of the rows are hidden in sheet1 because of other filters. Is this possible in google sheets?