Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
DME DME is offline
external usenet poster
 
Posts: 4
Default Count Highlighted cells

Is there a formula or VBA program I can use to count the cells that are
highlighted a certain color i.e. # of cells that are highlighted red or
yellow.

Thanks in advance!


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Count Highlighted cells

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html

-----Original Message-----
Is there a formula or VBA program I can use to count the

cells that are
highlighted a certain color i.e. # of cells that are

highlighted red or
yellow.

Thanks in advance!


.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Count Highlighted cells

Hi,

This should give you everything you need to know.

http://www.cpearson.com/excel/colors.htm

Sincerely,

Kris

-----Original Message-----
Is there a formula or VBA program I can use to count the

cells that are
highlighted a certain color i.e. # of cells that are

highlighted red or
yellow.

Thanks in advance!


.

Reply
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
COUNT HIGHLIGHTED CELLS IN A ROW ? Stephen the computer dummy Excel Discussion (Misc queries) 1 September 19th 08 10:29 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 PASSWORD37 Excel Discussion (Misc queries) 1 February 7th 06 04:34 AM
How do I count cells that have are highlighted a certain color? NicoleE Excel Worksheet Functions 1 September 2nd 05 09:14 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 06:15 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"