View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default If function with color or bold face

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