conditional formatting

[Fred]

I understand that conditional formatting is used to create a specific
format when a number matches a specified criteria. If I have a list of
eight cells with numbers in them, can I highlight the highest and lowest
number in the list with conditional formatting (both different colors)

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[JE McGimpsey]

one way:

CF1: Formula is =A1=MAX($A$1:$A$8)
Format1: Red

CF2: Formula is =A1=MIN($A$1:$A$8)
Format2: Blue

 

[Norman Harker]

Hi Fred!

Use Cell Value is:
Equal to

=MAX($A$1:$A$8)

Additional conditional format:

Cell Value Is:
Equal to

=MIN($A$1:$A$8)

If you have a non-contiguous cells in your list you'll need to use
(eg)

=MAX($A$1,$A$4,$B$2,$B$5,$B$7,$C$3,$C$6,$C$8)