Hello Jacob,
Thanks for your reply. I really do need both conditions for my report. If
conditional formatting won't work, is there an alternative?

"Jacob Skaria" wrote:

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 FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=$B1=""

4. Click Format ButtonPattern and select your formatting
5. Hit OK

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.


--
Jacob (MVP - Excel)


"BlueAngel" wrote:

I would like to apply conditional formatting for my spreadsheet with the
following:

Condition 1: If Column C Font is Bold then bold entire row and interior
shade entire row gray.

Condition 2: If Column B is Blank then shade entire row light yellow and
format entire row font italic.

Can't seem to figure out the formula for this. Any help is greatly
appreciated.