Highlight Cell based on Value of another Cell

[Andy16H]

I am using the following formula in Column G, Sheet, Micros Sales Reports =IFERROR(MATCH(E2,'Bank Statement'!E:E,0),"")
The formula returns a row number for the match and works great.

If the above formula returns a 5, I need to highlight cell E5 on the Bank Statement Sheet
If the above formula returns a 73, I need to highlight Cell E73 on the Bank Statement sheet and so on all the way through the sheet.

I also need to place a X in the cell to the right of the cell that is highlighted.

 

[CodeNinja]

Using conditional formatting, this would be easy. You simply need to turn that formula into trues and falses... Highlight E1 to E100 (if you want to go to E2000, highlight E1-E2000 etc) and create a new conditional formatting rule (home ribbon, conditional formatting, new rule) using the formula

=IFERROR(MATCH(E2,'Bank Statement'!E:E,0),"")=ROW(E1)

Be sure the active cell in your highlighted range is E1 of course... then format it to whatever you want.