I'm pretty new to writing macro. I have two sheets in my spreadsheet. If sheet1 contains a cell with the text word "Error" it will highlight the cell in another sheet called OrderReport.
The data is contained in Cells A6:L300 in Sheet1.
Example if the word Error is in Cell A6 in sheet "Sheet1" i need Cell A6 highlighted in Sheet "OrderReport"