Reply to thread

Message: [QUOTE="Jacob Skaria, post: 3287538"] Oops.. --Conditional formatting could be done only based on cell values and not based on cell formatting... --To apply formatting to the entire row based on ColB blank values 1. Select the rows to be formatted. Please note that the row reference 1 mentioned in the formula is the active row in the selection. Active cell will have a white background even after selection 2. From menu Format>Conditional Formatting> 3. For Condition1>Select 'Formula Is' and enter the below formula =$B1="" 4. Click Format Button>Pattern and select your formatting 5. Hit OK PS: If you are using XL2007 Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format. Enter the formula in the box below. [/QUOTE]