Ideas on vba to do the following: On Sheet1, starting w/ Column AC, Row 4 take the first cell (that has red font) and try to locate a match on Sheet2 within Column C, starting with Row 2 going down.
=If match found, turn background of that cell on Sheet1 to blue.
=If not found, move to next red font cell within Sheet1, Col AC and repeat search.
*Important: if it comes across a cell in Col AC that has any other font color, ignore it and only search using cells with red font.
=If match found, turn background of that cell on Sheet1 to blue.
=If not found, move to next red font cell within Sheet1, Col AC and repeat search.
*Important: if it comes across a cell in Col AC that has any other font color, ignore it and only search using cells with red font.