| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) | |||
Linear Mode
