Supposing I want to give a formula that if a particular cell is 40,
=if(c440)
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: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=499111

Select all the cells you wish to format. Format, Conditional Formatting,
Cell value is, Format Font to BOLD and format pattern to green,

Gilles
"SH" wrote in message
...
Supposing I want to give a formula that if a particular cell is 40,
=if(c440)
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

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
"SH" wrote in message
...
Supposing I want to give a formula that if a particular cell is 40,
=if(c440)
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

Hi sh,
Use Conditional formatting.
FormatConditional formatting...
Condition 1
Cell Value Is greater than 40
Format...
Font tab click bold
Patterns tab click the green color
Click OK
Ken Johnson

Hi sh,
Use Conditional formatting.
FormatConditional formatting...
Condition 1
Cell Value Is greater than 40
Format...
Font tab click bold
Patterns tab click the green color
Click OK
Click OK
Ken Johnson