VBA Conditional Format Cells based on multiple condition

HI,
I am trying to add conditional formatting to a sheet in the workbook through a macro. I have multiple conditions in columns H & K & P; if column 'F' has certain value then color of row changes based on range. Then I want that row to change if the value in column 'H' is either "Approved, Resubmit, Rejected", if 'Rejected' the row would change to different color (red).

Below is the code I have so far, don't relly know how to add additional condition through Macro. I am able to do this within the sheet with multiple condition but, I am having issues with it when I combine data from other sheets. So, need to go Macro route.

Please Login or Register  to view this content.

Thanks.

Hello nimesh29,

Rather than having Forum Members creating a Workbook which they assume represents your exact requirement, to guess a possible solution, may I please suggest you attach a sample workbook.

Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

Hello nimesh29,

Thank you for the feedback.

I have prepared a sample Workbook for you with Conditional Formatting, without using VBA Code. Please see if you can work with it.

Regards.

Hello nimesh29,

Thank you for the feedback.

Please could you copy the Forum with such a Workbook that, when it Combines the information it pushes the rules(cells) down and Conditional formating doesn't get applied.

Thank you.