PC Review


Reply
Thread Tools Rate Thread

Count with formatting

 
 
mns
Guest
Posts: n/a
 
      4th Mar 2010
Hi,
I have used to styles which are pre-defined in office 2010 one of them is
greeny one named Good and yellowish one named Note.
I would like to count the rows styled/formatted with these ones.

I want to spesify the range( lets say $E1:$E256) then want to see
how many cells are formatted with Good style or Note Style.
thank you in advance
 
Reply With Quote
 
 
 
 
Eduardo
Guest
Posts: n/a
 
      4th Mar 2010
Hi,
see CPearson web

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

hope this helps

"mns" wrote:

> Hi,
> I have used to styles which are pre-defined in office 2010 one of them is
> greeny one named Good and yellowish one named Note.
> I would like to count the rows styled/formatted with these ones.
>
> I want to spesify the range( lets say $E1:$E256) then want to see
> how many cells are formatted with Good style or Note Style.
> thank you in advance

 
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
COUNT IF - Conditional Formatting KC Microsoft Excel Misc 2 30th Oct 2009 04:38 PM
Bob P - Count conditional formatting =?Utf-8?B?bWFyeWo=?= Microsoft Excel Programming 8 6th Apr 2007 01:02 PM
Code For Count on Conditional formatting =?Utf-8?B?QWFyb24=?= Microsoft Excel Programming 1 5th Apr 2006 07:30 PM
Re: Count conditional formatting Tom Ogilvy Microsoft Excel Programming 0 23rd Aug 2005 01:52 PM
Count Conditional Formatting LD Microsoft Excel Programming 5 14th Oct 2003 10:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:14 AM.