Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Story: I have several accounts that we ship supplies too. My excel sheet
lists every account number we have and the number of times we have shipped them supplies in a six month time frame. Question: How can I set up the worksheet so if I want any of my accounts that appear on my list more than 10 times, it appears in red or bold or any type of indicator that makes that account or multiple accounts stand out. There are over 1000 accounts and I want to determine the top 50 or 100 worst offenders. Thank you to anyone who assists. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditioning Formatting - Thicker Borders | Excel Worksheet Functions | |||
Blank Cells - conditioning format | Excel Discussion (Misc queries) | |||
conditioning | Excel Worksheet Functions | |||
Date conditioning format problem | Excel Discussion (Misc queries) | |||
help with cell conditioning? | Excel Worksheet Functions |