View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Mon, 10 Oct 2005 13:46:04 -0700, "dbrumit"
wrote:

I would like the lowest value of columns d ,e, & f to be bold. Some of the
cells have text.

Thank you,

Dan


Highlight columns D:F

Format/Conditional Formatting

Cell Value Is Equal To =MIN($D:$F)

Format/Font/Bold
OK
OK

If there is an error in the range, then nothing will be formatted bold.

If that is a problem, you could set up two conditions: have the first format
RED, for example, if there is an error, and the Second Bold for the MIN number.

For condition 1, after highlighting columns D:F, use the Formula Is: Parameter

Formula Is: =TRUE=ISERROR(D1)
Format/Font Bold Color Red
OK
OK

and use the above for Condition 2


--ron