Hi Everyone,
I am creating a spreadsheet and I have 5 columns that have conditional formats set up so they are highlighted if each column contains information that will need to be reviewed. Is there a way to create another column that will show "REVIEW" if anything in Columns H-L have something highlighted? Each column has different data in it so I'm trying to figure out how to create something that will look through columns H-L.

If there is anything else you can think of that will solve the issue I am open to suggestions. I am trying to eliminate having scattered cells highlighted throughout the workbook and instead have one column that either says "REVIEW" or "OK TO PROCESS".

Here is a little example of what each column is looking for:
Column H:
If column H says "MATCH" its OK to process
If column H says "DOES NOT MATCH" it needs to be reviewed

Column I:
If column I says "VALID" its OK to process
If column I says "INVALID" it needs to be reviewed

Clumn J:
If the amount in column J is less than 0 it is OK to process
If the amount in column J is greater than 0 it needs to be reviewed

Column K:
If column K says "NEW" its OK to process
If Column K says "UPDATE" it needs to be reviewed

Column L:
If column L says TRUE its ok to process
If column L says False it needs to be reviewed

I was thinking of an IF formula but it would need to be written if H-L has ANY of those items so I'm not even sure where to start. I would really like to get it all in one column that either says "REVIEW" or "OK to Process"

Thanks for the help!