Conditional Formatting

**TERRI LEE** · 03-18-2013, 05:49 AM

Please Login or Register  to view this content.

Hi I have attached the code I have for running a macro that consolidates many sheets into one master sheet within a workbook. I want to know if it is possible to get the macro to run some conditional formatting as per below:

1. To highlight blank cells in column C if there is text in column B
2. To highlight cells in column H (only if they contain a value) if there is no info in column J
3. To highlight values in column K if the value is below or 2

Hope someone can help me here.

Thanks

**arlu1201** · 03-18-2013, 06:23 AM

Since you are not deleting the "Master" sheet, you can have preset conditional formatting set on the sheet. As soon as the data is populated, the colors will show.