LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Conditioning??

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditioning Formatting - Thicker Borders Fancy1 Excel Worksheet Functions 2 May 21st 06 04:35 PM
Blank Cells - conditioning format seanrigby Excel Discussion (Misc queries) 5 May 9th 06 05:08 PM
conditioning DONNA Excel Worksheet Functions 8 November 7th 05 04:29 PM
Date conditioning format problem [email protected] Excel Discussion (Misc queries) 1 November 1st 05 09:37 AM
help with cell conditioning? Bill L Excel Worksheet Functions 1 November 13th 04 07:52 AM


All times are GMT +1. The time now is 12:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"