i have an excel document, how do i highlight the highest number in each row?

0 ⤊

i have an excel document, how do i highlight the highest number in each row?

please help thanks

2007-04-25 15:12:04 · 2 answers · asked by mb 1 in Computers & Internet ➔ Software

2 answers

You can use conditional formatting to do that. I don't recall the specific formula you'd use, but I believe it would be something like =MAX(A1:E1) where A1:E1 is the range that you're trying to find the highest value for. You'd then be able to specify how you wanted that particular value formatted.

2007-04-25 15:20:29 · answer #1 · answered by Anonymous · 0⤊ 0⤋

Use the MAX function in Excel. Look up the syntax or how to format the function in the help section of Excel.

2007-04-25 15:19:28 · answer #2 · answered by Stareyes 5 · 0⤊ 0⤋