Counting Bold Cells

Apr 10, 2007

in the Score column I want a 3 for the SnAkEs team and 7 for the dj2 team. How do I total up the bold cells?

View 9 Replies


Merging Cols Changes Bold To Non-bold Or Non-bold To Bold

Jun 8, 2008

I am merging columns. Col B has all text in bold. Col C has all text in regular font. When I use ASAP to merge, the merged column comes out all bold. When I use a formula to merge the merged column comes out all regular. What I want is for the merged column to contain the bold text from Col B in bold, and the regular text from Col C in regular.

What I want is...

This is for service plan B: Take all data and transer to new server.

What I am getting is...

This is for service plan B:Take all data and transer to new server.


This is for service plan B:Take all data and transer to new server.

View 9 Replies View Related

Delete All Text Which Is Not 'bold' In Cells With 'mingled Bold' Text

Jan 23, 2010

I want to have a function or macro that if cells have mingled bold text, that only the bold text shall remain in the cells, and all the rest of the text must be deleted.

View 4 Replies View Related

How To Run Macro If Selection Is Not Bold And If Bold Then Do Nothing

Aug 5, 2012

How do we run a macro if the selection is not bold and If bold then do nothing.

View 3 Replies View Related

Make 1 Cell Bold If Another 1 Is Bold

Oct 2, 2007

I am trying to create a macro that if a value in a cell in column A is bold, then the value in the same row in column H is bold, then loop it to run on the rest of the worksheet.

View 9 Replies View Related

BOLD - Contents Of Cells In 2003

Nov 12, 2008

I cannot "BOLD" the contents of cells in my spreadsheet by clicking "B" on the menu bar. However I can do so by clicking on "Format - Cell - Font" and then using the selecting the Bold option. I wonder why this happens.

View 2 Replies View Related

BOLD And UNDERLINE Concatenated Cells

Apr 23, 2006

I need bolding and underlining cells that are "Concatenated". For example, cell format for cell K12 is already bolded and underlined. If I concatenate (C1,K12,D2) I get a result that doesn't carry over the format of those individual cells - particularly K12 which I want BOLDED and UNDERLINED.

View 9 Replies View Related

Count BOLD Cells In A Column

Sep 7, 2007

How to count cells in a column that are in BOLD

I looked all over couldnt find it.

View 9 Replies View Related

Split Cells By Bold Text

Jul 22, 2008

I have a sheet full of names, addresses and phone numbers in one cell like this

Albert Young 16 teststreer 12C..................7888-6338

The name Albert Young is bold. The thing is I would like to split the cell putting the names in another colomn. Then it would be ideal to split the addresses and phone numbers as well. But I have no idea how to split any of these. I scanned this from a phone book, the dots are different on each row.

View 9 Replies View Related

Bold On Copying Cells Which Has A Forumula

Oct 17, 2008

when he copies some data across a worksheet - the new data has a bold format, so he has to unbold everytime.

I can't see any obvious reason why this is happening.

View 9 Replies View Related

How To Count Bold Cells In Excel Sheet

May 28, 2013

How to count the bolded cells In an excel sheet using the formula

View 1 Replies View Related

Making Cells With Text Bold And In Grey

Jan 16, 2012

I have a spreadsheet with rows of cells which are either blank or have text in them.

Is there an easy way to write a formula which will make the cells which have text in them bold and make the cell colour grey. But if the cell is blank keep the cell white.

View 3 Replies View Related

Click Option Button To Make Cells Bold

Mar 25, 2007

Public Sub OptionButton1_click()
ActiveSheet.OLEObjects("OptionButton1").Interior.Font.Bold = True

End Sub

The problem i have is when i click on one of the option buttons it should change the cells ive highlighted to bold.

View 9 Replies View Related

User Define Function To Count Bold Cells

Oct 16, 2007

I currently have this macro that helps me SUM all the cells that are bold.

Public Function SumBold(Rng As Range)

Dim Total As Double
Dim Cell As Object

For Each Cell In Rng
If Cell.Font.Bold Then Total = Total + Cell.Value
SumBold = Total

End Function

I want to have the same kind of Macro, but that could COUNT the number of cells that are Bold.

View 9 Replies View Related

Macro Seems To Make Entire Text String In Cells Bold

Aug 1, 2014

I have the following code:

[Code] ..........

However, whenever I run the code, if there's even on word that is bold in the cell, then the entire text string in the cell turns bold. How can I stop this from happening? i want to keep the format of the text string the same, only remove and replace the items listed in the code.

View 4 Replies View Related

Copy Cells From Column To Adjacent Column If Bold Or Empty

May 20, 2008

I have a worksheet on which the data is already grouped. At the top of each group is a row that contains only the group name. Since the rest of that row is blank, I want to use a blank cell on that row as a reference, then copy the group name to a newly created column, then fill that column down to the next group.

The goal is to create a column that contains the group name, rather than just having the group name as a " header" at the top of each group.

View 5 Replies View Related

Counting Cells That Are Different

Oct 23, 2007

Is there a function in Excel that will count cells that are different from one another? I.e. it would not count the same value twice. For example, in column A:


The result would be 3. However, if I replaced the first "a" with a "d" I would get 4 as a result. Basically I want to know how many different arguments there are in a list. I could not find a function that does this in the Excel list of functions.

View 5 Replies View Related

Counting Particular Cells

Nov 22, 2008

I am now attempting to do the same type tally except I want a tally for "in conference" Wins/Losses.

I tried the same "SUMPRODUCT" formula as before except this time I held the control key down so as to use only the cells desired. I'm getting "VALUE" for my answer though.

The row I have added in for in conference tally is row 3.

All blue colored cells are for the ACC conference and the green are for the SEC.

Is there a way to get the win/loss figures for selected cells / rows only?

View 8 Replies View Related

Counting Cells

May 5, 2009

I am trying to create a formula to count the # of names up to a certain word. So Cells A1-F1. Are a list of names, the Last name in the list starts with VACANT. How do I create a formula to count the # of names in the list upto the work VACANT? So if VACANT moves to C1 it would decrease the # of names.

View 9 Replies View Related

Counting Cells Within Vba

Apr 27, 2007

I have written some VBA code to to test if there are 8 names within a range (EF5:FH5, these are 8 merged cells, (4x4 cells)), if there is 8 names within the cells, ie not any empty cells, then the coding will add the new staff name to "trigger_box_1b", and if not then "trigger_box_1a". These trigger boxes are then used to populate further cells.

Private Sub Trigger_Box_1_Change()
Windows("Admin Skills Matrix.xls").Activate 'puts focus on correct spreadsheet
Sheets("Skills Matrix").Select 'puts focus on correct page
Select Case WorksheetFunction. CountIf(Range("EF5:FH5"), 0).double
Case 0
Trigger_Box_1b.Text = New_Staff_Name
Case Else
Trigger_Box_1a.Text = New_Staff_Name
End Select
End Sub

the problems I have be having is that VBA is not recognising the Countif function ("Compile Error: Invalid qualifier", then highlights the Countif). I have tried using a CountA function with the same responce. I have tested the rest of the coding and know that it's working fine (don't think anyone would like to see 75+ pages of VBA coding)

View 3 Replies View Related

Counting Cells With Zero But Not Blank Cells

Oct 18, 2009

I know this question may have been posted before, but I can not seem to get this to work with my formula. I have a formula to count the values of a column so that I can convert it to a graph. I am giving a value of 1 to cells that contain numbers between 0 and 9.5 and giving a value of 0 to cells that contain numbers greater than 9.5. It works fine except that I have some blank cells that I do not want to get rid of and it is counting those as zeros and giving them a value of one. I want to ignore the blank cells or give them a value of zero.


View 9 Replies View Related

Counting Number Of Cells

Mar 24, 2014

My data is as follows:

Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Number of Starts 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
Rolling Number of Cases 10 20 30 40 50 60 70 80 90 100 110 120 120 120 120 120 120

In my dataset above the cases finish after 12 months (hence why there is a maximum number of cases).

What I am seeking is a method to count along a certain number of cells, then sum the contents of those. For example, I would like to count the contents of up to 12 cells, then sum those 12 cells.

Where it gets difficult is as follows:

- In month 6, I am just counting the contents of 6 cells (months 1-6)
- In month 12, I am counting the contents of 12 cells (months 1 -12)
- In month 18, I am counting the contents of 12 cells (month 7 - 18)

View 5 Replies View Related

Simple Counting Cells

Mar 5, 2009

way to count cells in a spreadsheet (not values in the cells but just the cells themselves). So I have a whole bunch of cells, some are red, some are blue, some are green based on the info i have to keep track of.

so can i write some COUNTIF for red cells green cells, etc

View 14 Replies View Related

Counting Cells That Are Blank

Feb 4, 2010

I have attached a spreadsheet with some tele numbers. What i need to do is to find out which column only has 1 telephone number, eg. only a cellphone number, etc. I have aboout 50 000 records that i need to check if only 1 telephone number is available. Can i use the countblank function?

View 2 Replies View Related

VBA Counting Cells With Borders

May 19, 2014

A cell on sheet1 needs to count the number of cells on sheet2 (D3:D31) that has a complete (top, bottom, left and right) border. This is my best shot at it.

[Code] .....

Sheet1 cell I input =CountBrds('sheet2'!D3:D31)

One issue, on sheet2 for example cell D4 is merged with E4 and F4 as is every even cell in the D column down to row 30. Not sure if that throws a wrench in things or not.

View 4 Replies View Related

Counting Cells That Are Not NULL

Aug 25, 2009

I have a large number of customers listed in an excel sheet that may recieve a visit from my organisation. The reason for the visit may vary and sometimes a customer may recieve more than one visit. Each Row (or record) maps to a customer. Each column has a visit type which I insert a date in to say when the customer has been visited.

I am looking for a function that will return if a customer has been visited or not. As dates can be summed like numbers I am currently saying in the "Visits Recieved" column =if(sum of dates (visit type colunm) >0, 1,0) Then I simply sum the column to get my answer of how many csutomers have been visited.

View 2 Replies View Related

Counting Only Unique Cells ...

Jun 9, 2006

I have a column (within a database) containing hundreds of Project Numbers
(e.g., P8763, PA3229, P1090.1, etc.), and the same Project Number can appear
more than once in the column. I need to count the number of unique Project
Numbers within that column, based on the criteria of another column. Is
there a way to do that using a combination of the DCOUNTA function and a

View 11 Replies View Related

Counting Blank Cells

Nov 25, 2006

I am trying to write a formula for the following can anyone help please?
I have column D with blank cells and some with purchase order numbers in them. I want to count the blank cells in column D but only if the blank is 3days older than the date recorded in column A. Once I have done this I want to count ther same on every work sheet and I have 24 off them and get one answer.
This will tell us all the outstanding purchase order older than 3days

View 9 Replies View Related

Counting # Of Cells That Are Overdue

Oct 28, 2008

I have a Column (G) of dates that is the sum of Column (B) and 6 months. I have conditionally formatted Column (G) to turn RED when overdue Yellow when close and GREEN if more than a month out. At the end of Column (G) I would like for it to add all the "RED" blocks and total them.

View 12 Replies View Related

Counting Characters Across Cells?

Jul 3, 2012

Cells in the range of BG8:BP8 either have a "W" or an "L" in them. I want to have cell BO9 display the total number of Ws and cell BP9 to display the total number of Ls.

View 3 Replies View Related

Copyrights 2005-15, All rights reserved