COLORING LOWEST FIGURE IN A RANGE

M

markstro

I would like to format the lowest figure in a range to a chosen color.
Can anyone provide a formula or conditional formatting that will do
this. The range will cover about 20 rows.
Thanks
 
P

Pete_UK

Assume data is in column A from A1 to A20. Highlight these cells, then
click Format | Conditional Formatting and in the dialogue box choose
"Formula Is" rather than "Cell Value Is", and in the panel enter this
formula:

MIN($A$1:$A$20)

Click the format button and choose Colour (for foreground) or Patterns
Tab (for background) and pick the colour(s) you wish. Click OK to
return to your sheet, which should now show the chosen colour(s) on the
smallest cell value.

Hope this helps.

Pete
 
H

hhenrion

Hi,

assuming your data is in range A1:A10.

Use conditionql formatting (formula is)
In cell A1 :
=(A1=MIN(A$1:A$10))
an select the format you want for that cell.

NB : if there are several cells with the lowest value, they will all be
highlighted.

Regards,

H.
 
Top