Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |