Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sjb1981
 
Posts: n/a
Default how do i sought coloured number cells from normal ones?

i have a spread sheet and and have two different faults being assigned in a
colum and want one to be in one colour and the other in another colour i want
to know how i can get a formula to keep count of how many are in each colour.
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Instead of counting colours, you can use a COUNTIF formula to count the
number of cells that meet each condition. For example:

=COUNTIF($A$1:$A$21,"Fault1")

sjb1981 wrote:
i have a spread sheet and and have two different faults being assigned in a
colum and want one to be in one colour and the other in another colour i want
to know how i can get a formula to keep count of how many are in each colour.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 10:02 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 05:21 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL JOHN MORREY Excel Discussion (Misc queries) 2 December 2nd 04 03:50 AM


All times are GMT +1. The time now is 08:36 PM.

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"