Largest value in a row or column
 

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
--
6-West

Largest value in a row or column
 

Yes.


Use the LARGE() function in your conditional format.
--
Gary''s Student


"sixwest" wrote:

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
--
6-West

Largest value in a row or column
 

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 :-)
------------------------------*------------------------------*----------------


"sixwest" wrote in message
...
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
--
6-West