Conitional formatting query

Giganews Newsgroups
Subject: Conitional formatting query
Posted by:  Stainless (stains_yah…@hotmail.com)
Date: 27 Oct 2003

I have 3 columns of data : A, B and C

These have numeric price values in them, although one or all could be
empty. I want to highlight the lowest value cell that is actually
populated.

e.g. A1 is empty, B1 is 3.50, C1 is 10.00  - B1 should be highlighted
as it is the lowest value

A2 is 1.25, B2 is empty, C2 is empty  - A1 should be highlighted

A3, B3 and C3 are all empty  - none should be highlighted.

Any ideas how I use conditional formatting to recognise the lowest?

Replies