Conditional formatting using a function?

[Sharon]

Hi all,

I would like to conditionally format a range of cells so that the cells that equal the MIN() or the
MAX() value are bolded. Is it possible to use a function such as:

=MIN(C27:E27)

as a condition to bold the cell's values?

Sharon

 

[Frank Kabel]

Hi
try the following:
- select for example the cells C27:E27
- goto the conditional format dialog
- choose in the left drop down 'Formula'
- enter the formula
=C27=MIN($C$27:$E$27)