| 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 |
| 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) | |||
Threaded Mode
