Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
color coding largest in a list
I have a list of 60 items that change slightly on a weekly basis. Currently
I highlight(color code) the five with the largest weekly increases. I do this with the following conditional format formula. =AND(ISNUMBER($P7),$P7=LARGE($P$3:$P$60,5)) I would like to highlight(color code) another group of five with the next largest weekly increases but have been unable to determine the appropriate formula. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list - color coding | Excel Worksheet Functions | |||
color coding | Excel Discussion (Misc queries) | |||
color coding | Excel Discussion (Misc queries) | |||
color coding | Excel Discussion (Misc queries) | |||
color coding | Excel Worksheet Functions |