PC Review


Reply
Thread Tools Rate Thread

counting highlighted cells or font color cells

 
 
New Member
Join Date: Dec 2007
Posts: 2
 
      10th Dec 2007
Hi all,

In excel 2000, I am trying to count the lines in a spreadsheet that has the first cell in each row highlighed in yellow. Additionally, I am trying to count the number of rows that has a red font in the cell in column D.

I have reviewed other posts by searching counting highlighted cells, but I do not understand how to complete the entire process. One of the suggestion was to create a vb script in combination with using =cellindex(??). I do not really understand how to create this, name it and the run it.

Or I would appreciate if someone would walk me through solving this problem.

Dan
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting cells by font color Cassie Microsoft Excel Misc 2 23rd Nov 2009 05:57 PM
counting highlighted cells or font color cells Tired Dan Microsoft Excel Discussion 0 10th Dec 2007 10:41 PM
Counting highlighted cells? =?Utf-8?B?Sm9zaCAtIFdlc3RmaWVsZCBBdXN0cmFsaWE=?= Microsoft Excel Misc 2 20th Apr 2005 09:20 AM
Counting cells with a Color Font Paul Microsoft Excel Worksheet Functions 1 24th Nov 2003 07:10 PM
counting highlighted cells Dragonstear Microsoft Excel Misc 1 17th Oct 2003 05:10 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:10 PM.