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