VBA to hide rows and apply cell colors based on multiple columns' values

[doconnor]

Hi! I'm trying to apply some conditional formatting to an Excel worksheet with a macro (using VBA). Below are the conditions and subsequent actions I'm looking to execute:

First:

hide all rows (in the entire active sheet) if the value of the cell in Column G ="BID", AND if the value of the cell in Column H <10000.00, AND if the value of the cell in Column I ="Orders, Web" OR ="cXML Orders"

Second:

hide all rows (in the entire active sheet) if the value of the cell in Column G ="MO", AND if the value of the cell in Column H <10000.00

Then, as another separate macro to run after the above two are run:

Apply RBG(253, 233, 217) color to any/all cells in Column G if the value of the cell in Column G is <10000.00

If you could provide some direction on this, I would be so grateful!