Conditional 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 in each row 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 and highlight it?
 
Hi

What was wrong with Biff's suggestion to your last post?

Andy.

Stainless said:
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 in each row 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 and
Click to expand...
highlight it?
 
Back
Top