|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
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?