software

Supposing I want to give a formula that if a particular cell is gt; 40,
=if(c4gt;40)
1) make the color green else let it remain as it is
2) Highlight it in bold face in black itself else let it remain as it is

Kindly let me have the answers for both 1) and 2).

Thanks in advance

Regards

sh
--
LEARNING MS OFFICE THOROUGHLLY


Why not use conditional format

Format/Conditional Format

Larry--
keithl816
------------------------------------------------------------------------
keithl816's Profile: www.excelforum.com/member.php...oamp;userid=21287
View this thread: www.excelforum.com/showthread...hreadid=499111Select all the cells you wish to format. Format, Conditional Formatting,
Cell value is, Format Font to BOLD and format pattern to green,

Gilles
quot;SHquot; gt; wrote in message
...
gt; Supposing I want to give a formula that if a particular cell is gt; 40,
gt; =if(c4gt;40)
gt; 1) make the color green else let it remain as it is
gt; 2) Highlight it in bold face in black itself else let it remain as it is
gt;
gt; Kindly let me have the answers for both 1) and 2).
gt;
gt; Thanks in advance
gt;
gt; Regards
gt;
gt; sh
gt; --
gt; LEARNING MS OFFICE THOROUGHLLY
Please respond to the group, not to my e-mail. Your next question is
answered by going through the same steps and clicking on the FONT tad and
changing the colour of the font only,

Gilles
quot;SHquot; gt; wrote in message
...
gt; Supposing I want to give a formula that if a particular cell is gt; 40,
gt; =if(c4gt;40)
gt; 1) make the color green else let it remain as it is
gt; 2) Highlight it in bold face in black itself else let it remain as it is
gt;
gt; Kindly let me have the answers for both 1) and 2).
gt;
gt; Thanks in advance
gt;
gt; Regards
gt;
gt; sh
gt; --
gt; LEARNING MS OFFICE THOROUGHLLY
Hi sh,
Use Conditional formatting.
Formatgt;Conditional formatting...
Condition 1
Cell Value Is greater than 40
Format...
Font tabgt; click bold
Patterns tabgt; click the green color
Click OK
Ken JohnsonHi sh,
Use Conditional formatting.
Formatgt;Conditional formatting...
Condition 1
Cell Value Is greater than 40
Format...
Font tabgt; click bold
Patterns tabgt; click the green color
Click OK
Click OK
Ken Johnson