Conditional Formatting BOLD

[Shhhh]

Hello all.

In words what I want is:

IF A2 is not blank then A1 = bold. IF A2 is blank then leave text as
it.


Thank you all for your help.

 

[AltaEgo]

Your conditional formatting formula is

=ISBLANK($A$2)

How to set conditional format:

XL2003
http://office.microsoft.com/en-us/excel/HP051992781033.aspx?pid=CH010036941033
Also
http://www.contextures.com/xlCondFormat02.html

XL2007
http://office.microsoft.com/en-us/excel/HP100739391033.aspx?pid=CH100648451033
(see Use a formula to determine which cells to format)

 

[DILipandey]

Hi,
Use the following formula in conditional formatting:-
=NOT(ISBLANK(A2))
and choose the format as "Bold".
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India