Conditional formatting using a function?

  • Thread starter Thread starter Sharon
  • Start date Start date
S

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
 
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)
 
Back
Top