Bold Row If Column A Equal To Certain Value?

Mar 11, 2013

The following code doesn't seem to work for me except when I use an actual number.

Set MR = Range("A1:A100")
For Each cell In MR
If cell.Value = "*3L*" Then cell.EntireRow.Font.Bold = True
Next

I am attempting to bold the entire row if the macro finds text that begins with 3L in a tab. If I change the code to look for a number, then it works fine.

Also - Is there a way to make this run on specified tabs? For instance, if I have four tabs:

January
February
March
Q1

Say I only want it to run on the January, March, and Q1 tab, how would I go about doing that?

View 2 Replies


ADVERTISEMENT

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.

View 9 Replies View Related

Countif- Where Column A Is Equal To A Specific Number And Column B Is Equal To Another Number

Jun 29, 2008

I'm trying to count if there are situations where column a is equal to a specific number and column b is equal to another number.

both columns are numbers. Does anybody have a good idea how to do this, maybe countif, but i am not sure how to do more than one item with that.

View 9 Replies View Related

Conditional Formatting (largest Number In Column B The Hotel In Column A Should Be In Bold)

Oct 18, 2008

when the largest number in column B the hotel in column A should be in bold.

So in excel language IF(Number in B Is Max display corresponding hotel in column A as BOLD. But I can't figure out how to do this.

You can see here on the image:
additionalimage.gif

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

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

Bold Selected Text In A Column

Jan 30, 2007

Every week I have a worksheet compiled with large range of data, being input after many meetings done. The action-owner Names in open/close brackets are among the long text input in one Column (there are not more than 50 rows of data).

My problem is that in the Column every time I have to manually Bold-face the owner names in the cells that have their names, pressing F2 and Bold. Examples: ...(Wilfred)... or ...(Jacky/Joseph)... Can someone please help me with a code, say I can list out a fixed list of selected text and such code will be able to have these selected text (which is names in this case) in the cells bold-faced.

View 7 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

Find End Of Column And Bold Rows In Loop

Oct 17, 2007

I am trying to Find a cell containing a string ("derf" in this case). Then bold the entire row and continue to loop till it hits the end of the row and column.
Here is what I have.

Sub Macro3()
Range("B65536").End(xlUp).Select 'Finds the bottom in column B and sets it to endhere
ActiveCell.Value = "endhere"
Range("A1").Select 'goto the top
Do Until ActiveCell.Value = "endhere" 'The Do Loop Starts
Rows("1:30").Select
Set rfoundcell = Selection.Find(What:="derf", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)
With rfoundcell
rfoundcell.EntireRow.Font.Bold = True
End With
Loop 'Keep looping till it hits the bottom of the columns row!
End Sub

View 2 Replies View Related

Count Values Of Column If Column Header Is Equal To Name In Column A?

Apr 25, 2014

For column "B" count all the 1's if column header is equal to name in column A.

For Column "C" needs to be checked if a value was filled in column "I" if yes then check if in column "L" has a value, count all these values.

View 5 Replies View Related

Bold Text In One Coloumn If The The Data In Another Column Is Checked

Nov 12, 2009

How can I change the format ie. Bold Text in one coloumn if the the data in another column is checked.

Basically, want the text in corresponding row of column "B2:B124" to be bold if the check box in the perspective row is checked?

View 9 Replies View Related

Match Names In Two Separate Column If Equal Then Pull Info In 3 Column?

Dec 6, 2013

I need to look up the name in E2 in the list in column A and if it matches then lookup name in F2 in list column b, if it matches then the corresponding number in column C is displayed in column G. If neither names are in the 2 columns the words"Not on lists" is displayed in cell in column G.

The other problem is one name is spelled two different ways I want it to look for both spelling before moving on to looking up the second name.

I started with this formula but I'm getting #N/A or "not on list" when they are on the list. I'm using ranges prod_sum is columns AthruC, Last_name is range BthruC. =IF(AND(VLOOKUP(F4,prod_sum,3,0),VLOOKUP(I4,last_name,2,0)),"not on list")

View 6 Replies View Related

Delete Duplicate Rows Where Column A And Column B Combined Are Equal

Dec 8, 2009

I have a sheet where i want to delete duplicate rows where column A and column B combined are equal, i.e. range(Ax:Bx) where x is the current row. I am using the macro below but cant seem to get it working as I keep getting a type mismatch error and Im not sure why.

View 2 Replies View Related

If Cell In Specific Column Contains Value Then Bold And Change Font Color For Entire Row

Mar 27, 2013

I'm trying to have a macro run to search a specific column (S) for a particular text value "y" and if true it will change the font to bold and the color to red for the entire row of the cell that contains the "y". the column is part of a data table that is constantly refreshed not sure if that makes a difference or not.

View 2 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

Count Column A If Value Of Column B Is YES And Column C Is Equal To 5

Apr 27, 2004

=COUNTIF(A19:A28,(AND(B19:B28="YES",C19:C28=5)))

What is wrong with my formula above? I am trying to count Colunm A if the value of Column B is "YES" and Column C is equal to "5".

View 8 Replies View Related

Dividing Column In Equal Parts?

Sep 15, 2014

Dividing column in equal parts divide a column in groups with the same rows and the same total sum? For example, I have the column A as following:

8,942

2,807

2,568

5,818

5,818

596

8,942

4,390

1,607

890

8,772

1,103

The total number of rows is 12 and total amount is 52,254

I want to divide the column in three equal parts with the same total. So each group must contain 4 rows with the total sum 17,418

View 9 Replies View Related

Average Values If Equal To A Value In Another Column

Jun 3, 2014

I have a table full of phone numbers and call durations.

In A2:A6160, I have 162 different phone numbers and in U2:U6160, I have the call durations for calls made to those numbers.

In a separate spreadsheet, I have each number listed in Column A and in Column D, I want to display the average call duration for each of the numbers.

View 3 Replies View Related

Sum Cell In Particular Row If Column Title Is Equal To Particular Value

Dec 23, 2013

I am working on a proforma statement, REFER THE ATTACHMENT

A B C D E F G H I J Q
1 jun'14 jun'14 jun'14 jul'14 jul'14 jul'14 Aug'14 Aug'14 Aug'14
2 beg. Inv Purchas Unit Sold Beg. Inv Purchas Unit Sold Beg. Inv Purchas Unit Sold
3 foundation 4 10 11 3 15 13 5 16 18
4 Lipstick 4 10 11 3 15 13 5 16 18
5 Shimmer 4 10 11 3 15 13 5 16 18
6 Powders 4 10 11 3 15 13 5 16 18
7 Nail Lacquer 4 10 11 3 15 13 5 16 18
8 Eye Shadows 4 10 11 3 15 13 5 16 18
9
10
11 Total Purchase for june to aug 2014
12 Foundation ??

this is just an small sample of what i am working on i have got purchases, cogs and ending invenory for 2 years Products wise i want to add purchases for the particular product.
i.e. if for above data i want to find out the foundation purchased through june 2014 to aug 2014 what will be the formula

View 4 Replies View Related

LOOKUP Value: Paired With Their Equal In Column A

Apr 26, 2009

This formula in E1 has worked before. I have attached an example, in reality Column A and B have 2000 rows and column D about 250 randomized numbers out of Column B that need to be paired with their equal in Column A.

View 4 Replies View Related

Count If One Column Is Equal To "N" And Another Column Is Equal To "N/A"

Oct 12, 2009

I need to apply two criteria to a COUNTIF. Eg, I need to count if one column is equal to "N" and another column is equal to "N/A", taking both criteria into account. At the moment it seems to knock one out when I try applying both!

View 9 Replies View Related

Sum Cells In One Column If Data In Next Two Columns Equal

Nov 13, 2013

I have three columns: Symbol, Dividend Payment, and Shares.

What formula will look at the shares column and symbol column and say if cells in column C are equal each other & cells in Column A are equal to each other than add all the div payment that correspond with those symbols and shares?

A
B
C
D

1
Symbol
Dividend Payment
Shares
Sum (Formula would go here)

2
SEB
.75
23

3
SEB
.75
23

(result desired) 1.5 (B2+B3) because (add the dividend where their symbol (A2&A3)and shares (C2&C3)are equal) both conditions have to apply to add div payment

[Code] ......

View 3 Replies View Related

Group All Records Where The Values In Column A Are Equal

Dec 24, 2008

I need to group all records where the values in column A are equal. BUT I needed them sorted by another column (the whole sheet, not just within each group). Currently, all of the values in column A are listed in random order. Is there any way to do this manually?

to elaborate a bit further, consider the following:

Columns: A-B-C-etc.
1-Z...
1-X...
4-X
3-Y
4-Y
2-Z

Basically, I need to group all of the "1"'s and all of the "4"'s so that the extra values will show underneath the other. HOWEVER, I need them to be sorted such that the order in which they appear are XYZ. So the goal would be:

1-X
1-Z
4-X
4-Y
3-Y
2-Z

View 9 Replies View Related

Delete Rows Column F If Greater Than Or Equal To Zero.

May 14, 2009

Starting in cell F3, if Column F is greater than or equal to zero, delete the entire row and continue deleting rows until Column A has contents in it. Then go to Column F in that same row that had contents in Column A, if the contents in that row of Column F are greater than or equal to zero, delete the entire row and continue deleting rows until Column A has contents in it. Persist with this pattern until every row in Column F has been checked.

View 4 Replies View Related

If Cells In Column L Is Less Than Or Equal To 2:00 (H:MM) Than Delete Entire Row

Dec 3, 2012

I need automatically deleting of whole row based on cell value, if value of cell which is in h:mm format, is less than or equal to 2:00 (h:mm)

So far I got.

Code:
Sub FillDownFormula()

Code:
Range("L2").Formula = "=RC[-3]-RC[-2]"
Range("L3").Select
Columns("l:l").Select
Selection.NumberFormat = "h:mm"
Dim rng As Range

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

View 2 Replies View Related

Erase The Entire Row If Column J Is Equal To 1205

Jun 6, 2006

I am trying to do is erase the entire row if column J is equal to 1205. I have made an attempt which is shown below, but I am no where near a VBA programmer, yet.


Sub Softrak_Format()
Rows("1:2").Select
Selection.Delete Shift:=xlUp
Cells.Select
With Selection
.WrapText = False
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False........................

View 4 Replies View Related

Sort Column With Equal Numbers And Linked Text

Jun 8, 2014

I would like to create a formula that will sort the numbers in column B, there are also equal numbers in this column

The difficult part is that there is text in column A, and is linked to the numbers

So if numbers are sorted the names should be sorted in the same way as well.

View 3 Replies View Related

Match Cells In 2 Columns And Return Third Column Value If Equal

Dec 24, 2013

I have 2 sheets with thousands of clients. One has client contact information and one revenue. I was able to put the 4 columns on 1 sheet. I need a formula that will say if the value of the client name columns match, (Client name) then return the value in the third column (revenue).

One other question, b/c i copied from a pivot table, i have the client name and their email address below in a separate row. Ideally i would have the client their contact and their revenue in 3 columns next to each other. Is there an easy way to bulk move the email address from the row below the column to the column next to the client name?

View 7 Replies View Related

Macro To Delete All Rows Containing Values Less Than Or Equal 300 In Column

Jun 11, 2014

Need a Macro to delete all rows containing values less than or equal 300 in column A

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved