LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default how to count number of highlighted cells in column

Within an existing worksheet I have a column of data containing cells that
are either highlighted in yellow (manually highlighted) or not highlighted in
yellow. I need to sum how many cells are highlighted in yellow and how many
cells are not highlighted in yellow. I'm running MS Office Excel 2003 SP2.
 
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
Can you count the number of cells that are highlighted in a column Mike Excel Worksheet Functions 1 October 13th 06 07:59 PM
How do I automatically count the number of cells highlighted Ferd Excel Discussion (Misc queries) 2 September 10th 06 07:00 AM
How do I automatically count the number of cells highlighted Ferd Excel Discussion (Misc queries) 1 July 7th 06 09:38 AM
Is there a way to count the number of highlighted cells in a col? Alicia Excel Discussion (Misc queries) 2 February 23rd 06 05:52 PM
Count highlighted cells Robbie in Houston Excel Worksheet Functions 2 February 16th 05 12:52 AM


All times are GMT +1. The time now is 07:28 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"