VBA Conditional Formatting based on cell value and Text

**uroy67640** · 06-08-2015, 04:27 PM

Hi All,

I want a VBA code which will help me to fill color index 40 in range A1:A1048576.

This code will based on conditional formatting which is mentioned below.

If the cell value of B2:B1048576 is equal to 2 then A2:A1048576 will be fill by color index 40 and if C2:C1048576 has text as Private equity then the range A2:A1048576 will be remain same or no color, but if the C2:C1048576 has other text then it will help to execute the first condition or it will act like a first condition only.

For reference I have attached one file.

**jaslake** · 06-08-2015, 07:46 PM

Hi uroy67640

You can try this...place the Code in Sheet1 Code Module

Edit: Delete your Conditional Formatting Rules...

Please Login or Register  to view this content.

**uroy67640** · 06-09-2015, 01:38 AM

Thanks for your reply.
Later I want to change the target column or cell. But above mentioned code I can not able to find any column name or cell range, so that I can apply this code in other column.

I want to put this code in module so that I can execute it whenever I want.