# 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

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

End Function

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

## Define When A User Selects Specific Multiple Cells

Nov 24, 2008

My worksheet with macros gets messed up when a user selects either multiple cells from column F or selects multiple cells in any one row (but only if column F is included) in the range C17:O116 and hits "delete". I will either do an exit sub, an application.redo, or something similar so that this doesn't happen, but I don't know how to write the code to trigger these events. So I need a way to determine "if the user selects multiple cells in column F and hits delete" or "if a user selects multiple cells in any row from 17 to 116 that includes the cell in row F, and hits "delete.""

Set Rng = Range("F17:F116")
Set rng2 = Range("K17:K116")
Set Rng3 = Range("L17:L116")

## 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.

## How To Count Bold Cells In Excel Sheet

May 28, 2013

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

## Define Merged Cells - Before Save Function

Oct 19, 2008

I used this forum to successfully prevent a user from saving a workbook without entering data in a certain cell. However, I now have a merged cell that I must refer to when writing my "before save" code and don't know how to refer to that cell. Below is what I have: One workbook with nine worksheets. The merged cells I want to refer to are H11 and I11 in sheet seven. User RYLO posted the below code that worked for me but I don't know how to alter it to refer to a merged cell.

## Conditional Formatting: OFFSET Function To Define A Range Inside A SUM Function

Apr 13, 2007

In Mr Excel's Pod Cast on April 12th, he showed how to use the OFFSET function to define a range inside a SUM function. Then he had Conditional Formatting that would highlight the range that was being summed. Can anyone tell me what the formula would be inside the Conditional Formatting dialog box to get the OFFSET range to have a certain format?

## Select User Define Page Size

Apr 22, 2006

how do i print on a3 paper? i can't find the option anywhere...i can select user define size but then where do i define it?!? i know this is a silly questions

## 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.

OR

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

## Changing The Color Of A Command Button :: To User Define Colors

Jan 29, 2009

so I know how to change the color of a command button(right click, properties), but is there a way to change the color to a specific red green blue range? lets say 102 28 02 for example

## 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.

## Count Only Bold Entries

Apr 21, 2007

is there any way to get a formula to count only the entries that are in bold abd ignore all others

## Define Range With Address Function

Dec 26, 2006

I am trying to create a correlation matrix that uses the =ADDRESS function to define the various columns of data which I want to correlate against each other (I require this flexibility because the number of columns and rows of data to be correlated will change). The basic formula I am using is something like the following: =CORREL((ADDRESS(Sheet1!\$C\$2+3,L2+2,,,"Sheet1")),(ADDRESS(Sheet1!\$B\$2,L2+2,,,"Sheet1")))

However, while the individual ADDRESS fomulas deliver the correct start and end cell references required, it seems that CORREL function won't accept the cell addresses that result from using the =ADDRESS function.

## Function For Determine If Cell Has 'mingled Bold Text'

Jan 11, 2010

I have the following formula (taken from the web) in my spreadsheet which let me know if a cell have bold text or not. But when the cell has 'mingled' text, i.e. only partly bold, he gave a #VALUE error.

## Define Argument Prompt On Function Module

May 6, 2009

I have made my own excel function that my users needs every day. it works just fine, however if you do not know the required argument for this function, you couldn't use it. How can i prompt my users for the right order of the argument when they type the function in excel?. example is when you type the Function "=left(" you will be prompted by excel of the correct arguments.

## Define A Range For SumProduct Function Based On An If Statement?

May 31, 2006

I want to calculate a weighted average but I need it to only calculate on the months to date. I have a data validation drop down on a title page that is toggled to the current month each time a report is needed to define what months have actuals. I bring in data for all the months but only the current months have actuals. I need to calculate the weighted average on ONLY the ACTUALS. How can I set the ranges for sum product based on the data validation list on the title page?

## Count Function For Multiple Cells

Apr 1, 2014

If cell D3 has the text string "RQS" and cell D2 is colored green, I want to count as one. The formula needs to apply to a range of cells. The end result being I want to know how many green cells are delineated at RQS.

## IF Function And Count A List Or Sum 2 Other Cells

Apr 9, 2009

I am trying to create an if function with different criteria to make it either count a list or sum 2 other cells

=IF(G2=0,SUM(INDIRECT("E1:E"&D1),if(G2>0,SUM(F21,I3))))

the first part of the formula works, however the second part returns a FALSE result.

## Average Function And Not Count The Blank Cells

Jul 10, 2008

I've got a spreadsheet that I do every month with columns of numbers that I average. This sheet has to match about 10 others similar. The columns are divided by Weekdays, Saturdays, Sundays. But some months there are no entries for certain cells on Saturday or Sunday.

I thought that if I just used the Average function, it would dismiss and not count the blank cells. Alas, apparently not. I've highlighted in yellow the one column that I'm really having trouble with.

## Function To Count Numbers Excluding Empty Cells

Jan 6, 2010

Is there a function that will count a column of numbers where that will eliminate counting empty cells based on a certain date that will also capture any numbers that is added after refreshing the table from Access? I have attached a spreadsheet for an example. I need to count on the number in column V that equals 13 for the date of 12/22/09.

## Count Unique Text Cells Ending In X - Function Only

Nov 15, 2013

I have some data in a column, starting at row 6 that I'd like to find the number of unique text values for. For this I have been using this formula

Code:
{=SUM(IF(FREQUENCY(IF(LEN(A6:A10000)>0,MATCH(A6:A10000,A6:A10000,0),""), IF(LEN(A6:A10000)>0,MATCH(A6:A10000,A6:A10000,0),""))>0,1))}

The data is dynamic so I picked an arbitrarily large number (10000) and the above formula successfully ignores blank fields.

However, I'd like to now find the count of unique text values that end in X. For example, let's say the data are as follows

Dog_Cat
Mouse_Dog
Mouse_Cat
Mouse_Cat
Mouse_Cat
Mouse_Mouse
Elephant_Elephant

How would I go about (in one function) finding the unique values that end in "_Cat", in this case 2 ("Mouse_Cat" and "Dog_Cat")?

## Color Function To Count Cells Highlighted In Different Colors

Feb 22, 2010

using =ColorFunction to count cells highlighted in different colors.

Is that function available in Excel 2007 under a different function name?

## 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?

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## Exl2K User: Sheet Is Password Protected But User Can Change Color In Unlock Cells

Jun 16, 2006

find attached zip file . if you open the file then you can understand the problem.

I need to change cells color and text color as per user choice in Password protected sheet : (user is useing excl2000)

Kindly open attahced file i putted the note inside the file.