Script for macro

[JAZZWAKEFOREST]

IWorking on worksheet:

Have column I, which will need to have a logic of:

If Column J = Column H then red text that reads "MATCH"

If Column J does not equal Column H then red text that read "REVIEW"

My actual question is: Is there a script that I can write to tell the spreadsheet to check Column J to see its relationship to Column H and inform me if I have a match or if I need to review the info. It must do this for each row.

Thanks

 

[Andrew Poulsom]

Can't you use a formula, eg?

=IF(H1=J1,"MATCH","REVIEW")

 

[JAZZWAKEFOREST]

Will this populate each row? Or do I have to type the formula for each row?

 

[Andrew Poulsom]

Enter it in the first row and copy it down.