Conitional formatting query

  • Thread starter Thread starter Stainless
  • Start date Start date
S

Stainless

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?
 
In CF, select all of the cells to apply it

change the condition to Formula Is
add this formula
=A1=MIN($A1:$C1)
format as desired

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I'll give this a go. However, once I have tried this in one row (eg A1
to C1), how do I apply the same formula through all the other rows in
each column (eg =A2=MIN($A2:$C2)... in other words how do I copy this
all the way down the column in a large worksheet)
 
Hi Stainless,

Select the entire range that you want this to apply to.
For example, select(highlight) A1:C100. Then goto
Conditional Formatting>Formula Is and enter the formula
exactly as written. The formula references will
automatically adjust throughout the range.

Biff
 
P.s. - (eg =A2=MIN($A2:$C2)...

That formula will fail if all cells in a given row are MT.
Use this:

=AND(A1=MIN($A1:$C1),A1<>"")

Biff
 
Back
Top