Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 2nd 05, 11:39 AM
Ken G
 
Posts: n/a
Default Count non-colored cells

I have a sheet that highlights cells in a range if any of
those cells contain values from a manually entered range
using the "countif" function and conditional formatting.

How do I count the number of cells which have been
conditionally formatted - with a fill color.

  #2   Report Post  
Old January 2nd 05, 11:48 AM
Ken G
 
Posts: n/a
Default


-----Original Message-----
I have a sheet that highlights cells in a range if any of
those cells contain values from a manually entered range
using the "countif" function and conditional formatting.

How do I count the number of cells which have been
conditionally formatted - with a fill color.
.

Sorry - the Subject Line should have been "Count colored cells"
  #3   Report Post  
Old January 2nd 05, 12:15 PM
Frank Kabel
 
Posts: n/a
Default

Hi
though this is possible it's a little bit complicated. Why not use the same
criteria in a formula as you have don in the conditional format dialog
()e.g. use COUNTIF)

--
Regards
Frank Kabel
Frankfurt, Germany
"Ken G" schrieb im Newsbeitrag
...
I have a sheet that highlights cells in a range if any of
those cells contain values from a manually entered range
using the "countif" function and conditional formatting.

How do I count the number of cells which have been
conditionally formatted - with a fill color.



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
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM
linking cells in Excel 2003. How to not truncate to 255 characters. GarryFerg Excel Discussion (Misc queries) 5 December 8th 04 03:33 PM


All times are GMT +1. The time now is 11:30 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017