Highlight entire row based of multiple if conditions.

Using VBA,

I would like to highlight the entire row if 3 conditions are met. Attached is a spreadsheet of raw data as well as the ideal results.

Assuming that the data is dynamic the number of rows will never be fixed; however column A will provide the range for each row tested.


Thank you.

Hi nhi from Denver.

Put this code behind a module and see if it does what you want.

S

Please Login or Register  to view this content.