Largest value in a row or column

G

Guest

I have a several spreadsheets that are linked to a "master" spreadsheet where
numeric values are propagated into rows (range of 12) and columns (range of
18). Is there a conditional formula that can highlight the highest value in a
row/column at all times?

Thanks
 
K

Ken Wright

Take a look at Conditional Formatting and the MAX() or LARGE() function

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing part of data range 3
Having Blank Cells, etc. ? 1
Excel VBA 1
Find values across a row and return a text value from the same column 2
Countif wrong in last row or two 3
Macro to sort numeric rows left to right 14
Conditional Formating - by row, not by column (Office 2007) 1
can conditional formatting varry the area it highlights based on c 3

Top