Conditional Formating and Macros

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!

I've never done that before, but just glancing at it I don't see a way to have it add "REVIEW" to another column. Do you know how to do it?

I think what FDibbins was suggesting is that you could create a formula in whatever your "REVIEW" column will be that mimics your CF rules. For example, if you want the OK TO PROCESS/REVIEW to show up in column M, then in M2 you could paste a formula like:

=IF(AND(H2="MATCH",I2="VALID",J2<0,K2="NEW",L2=TRUE),"OK TO PROCESS","REVIEW")

...and fill it down through the rest of your rows. It should put "OK TO PROCESS" in row M if all five conditions are met; otherwise it'll return "REVIEW".