Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add column
hi,
I have a sheet withi like 500 or so rows. There is a column B with some of the values in Bold. I would like to add a column to the sheet which puts a "BOLD" in each row/column if the value in column B is bolded, and a value of "NOT" if it is not bolded. Is there a programmatic/fast way of doing this? Thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add column
Sub boldchk()
n = Cells(Rows.Count, 2).End(xlUp).Row Range("C1").EntireColumn.Insert For i = 1 To n If Cells(i, 2).Font.Bold = True Then Cells(i, 3).Value = "BOLD" Else Cells(i, 3).Value = "NOT" End If Next End Sub -- Gary''s Student gsnu200708 "geebee" wrote: hi, I have a sheet withi like 500 or so rows. There is a column B with some of the values in Bold. I would like to add a column to the sheet which puts a "BOLD" in each row/column if the value in column B is bolded, and a value of "NOT" if it is not bolded. Is there a programmatic/fast way of doing this? Thanks in advance, geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
add column
Sub macro1()
Dim c As Range Dim rng As Range Set rng = Sheets("Sheet1").Range("B1:B500") For Each c In rng If c.Font.FontStyle = "Bold" Then Sheets("Sheet1").Range("H" & c.Row) = "BOLD" Else Sheets("Sheet1").Range("H" & c.Row) = "NOT" End If Next c End Sub Change row numbers and columns to suit. Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C | Excel Programming |