If function with color or bold face

S

SH

Supposing I want to give a formula that if a particular cell is > 40,
=if(c4>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
 
G

Gilles Desjardins

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

Gilles
 
G

Gilles Desjardins

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
 
K

Ken Johnson

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

Ken Johnson

Hi sh,
Use Conditional formatting.
Format>Conditional 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
 
Top