Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
condtional format - hightlight max results
Have 3 columns, L M N which display percentage results based on values
entered in other columns (cells in columns contain count formulas) In these columns I want the max result to highlight in different color I tried cell value is - equal to - =max(L4:L20) but does nothing I tried formula is =L4=max(L4:L20) changes everything to red except for the lowest value |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
condtional format - hightlight max results
maybe...
equal to: =max($l$4:$l$20) or formula is: =L4=max($L$4:$L$20) (with L4 the active cell) Nadine wrote: Have 3 columns, L M N which display percentage results based on values entered in other columns (cells in columns contain count formulas) In these columns I want the max result to highlight in different color I tried cell value is - equal to - =max(L4:L20) but does nothing I tried formula is =L4=max(L4:L20) changes everything to red except for the lowest value -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
condtional format - hightlight max results
I tried
formula is =L4=max(L4:L20) changes everything to red except for the lowest value Use the above but change the formula to: =L4=max($L$4:$L$20) -- Biff Microsoft Excel MVP "Nadine" wrote in message ... Have 3 columns, L M N which display percentage results based on values entered in other columns (cells in columns contain count formulas) In these columns I want the max result to highlight in different color I tried cell value is - equal to - =max(L4:L20) but does nothing I tried formula is =L4=max(L4:L20) changes everything to red except for the lowest value |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
condtional format - hightlight max results
neither worked.
first one, changed nothing second one, only changed L4 to red and that one wasn't the max number "T. Valko" wrote: I tried formula is =L4=max(L4:L20) changes everything to red except for the lowest value Use the above but change the formula to: =L4=max($L$4:$L$20) -- Biff Microsoft Excel MVP "Nadine" wrote in message ... Have 3 columns, L M N which display percentage results based on values entered in other columns (cells in columns contain count formulas) In these columns I want the max result to highlight in different color I tried cell value is - equal to - =max(L4:L20) but does nothing I tried formula is =L4=max(L4:L20) changes everything to red except for the lowest value |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
condtional format - hightlight max results
Do you have all the $ signs in the correct place?
You want a fixed range but a relative cell............L4 Gord Dibben MS Excel MVP On Wed, 9 Jul 2008 20:11:01 -0700, Nadine wrote: neither worked. first one, changed nothing second one, only changed L4 to red and that one wasn't the max number "T. Valko" wrote: I tried formula is =L4=max(L4:L20) changes everything to red except for the lowest value Use the above but change the formula to: =L4=max($L$4:$L$20) -- Biff Microsoft Excel MVP "Nadine" wrote in message ... Have 3 columns, L M N which display percentage results based on values entered in other columns (cells in columns contain count formulas) In these columns I want the max result to highlight in different color I tried cell value is - equal to - =max(L4:L20) but does nothing I tried formula is =L4=max(L4:L20) changes everything to red except for the lowest value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL | Excel Worksheet Functions | |||
Condtional Format | Excel Discussion (Misc queries) | |||
Condtional Format Question | Excel Worksheet Functions | |||
condtional format to | Excel Worksheet Functions | |||
Condtional format of row depending on string value of $A2 + | Excel Discussion (Misc queries) |