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: 77
Default cell pattern - color

hi community

is it possible to count number of cells that has color pattern,
what i m saying:

example in A1:A5
and I have
A1 fill with color pattern
A3 fill with color pattern
A4 fill with color pattern

and I want to check whether in range A1:A5 how many cells have color pattern..
can I do such and if possible, how i do it?

thanks community for the help :)
--
oldLearner57
 
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
Date sensitive cell pattern color Darrell Shuman Excel Worksheet Functions 4 August 17th 06 04:26 PM
How do you control the color/pattern of a pie chart? Pie chart Charts and Charting in Excel 1 July 15th 06 10:57 PM
How do I change color pattern based upon a formula within a cell? aemuk Excel Worksheet Functions 1 June 16th 06 11:18 PM
Prefil Color Pattern in Excel David Excel Worksheet Functions 3 February 16th 06 09:44 PM
Pie Chart Color/Pattern cjc Charts and Charting in Excel 1 June 9th 05 04:07 AM


All times are GMT +1. The time now is 03:51 AM.

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

About Us

"It's about Microsoft Excel"