View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ed Ferrero Ed Ferrero is offline
external usenet poster
 
Posts: 115
Default Highlight highest / lowest number in a row

You can do this with conditional formatting.

Suppose that your series is in row 2.
Select cell B2. Format - Conditional Formatting...
Condition 1 - Select Formula Is
- enter formula =B2=MAX(2:2)
- click on Format and select a pattern
Click on Add
Condition 2 - Select Formula Is
- enter formula =B2=MIN(2:2)
- click on Format and select a pattern
Click OK
Select the cell you have just formatted, click the Format Painter button,
apply to whole row.

Ed Ferrero
http://www.edferrero.com


Hi,

How do you highlight the highest / lowest number in a row?

Example -

Jan - 77.9, 83.5, 88.9, 67.1
Feb - 91.1, 85.9, 73.8, 83.2

How do you make it to highlight 88.9 since it is the highest among row
for Jan
91.1 for Feb?

I may need to highlight for the lowest number as well in other sheets.

Thank you!!!!