A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Conditional Formatting Help



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2010, 02:29 PM posted to microsoft.public.excel.misc
BlueAngel
external usenet poster
 
Posts: 3
Default Conditional Formatting Help

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.


  #2  
Old April 20th, 2010, 02:46 PM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default Conditional Formatting Help

You havent mentioned the conditions for formatting these two columns..
--
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.


  #3  
Old April 20th, 2010, 02:53 PM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default Conditional Formatting Help

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.


  #4  
Old April 20th, 2010, 03:00 PM posted to microsoft.public.excel.misc
BlueAngel
external usenet poster
 
Posts: 3
Default Conditional Formatting Help

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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.