Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding verbiage to the end of a cell
I want to be able to add words to the end of a cell. For instance if
the cell contains "total for NY", I want to be able to add " < 10,000" at the end. The cell would need to say "total for NY < 10,000". Then I want the whole row highlighted in yellow. Can someone please help me with this? Thank you CP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding verbiage to the end of a cell
Below sub will check F column for "total for NY" when found it will
change it to "total for NY < 10,000". And color the row between A and K columns. Please make necessary changes to your needs. Rgds Sub color() Dim rng As Range Dim i As Range With Worksheets("Sheet1") Set rng = .Range("F2", .Range("F" & Rows.Count).End(xlUp)) For Each i In rng If i.Value = "total for NY" Then i.Value = "total for NY < 10,000" Range("a" & i.Row & ":" & "k" & i.Row).Interior.ColorIndex = 6 End If Next i End With End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding verbiage to the end of a cell
Assign a hoykey combination to a macro, containing these 2 lines of code: __________________________________________________ ____________________ ActiveCell.Value = ActiveCell.Value & " < 10.000" Range(ActiveCell.Row & ":" & ActiveCell.Row).Interior.ColorIndex = 6 __________________________________________________ ____________________ CE ActiveCell.Value = "jjnotme" wrote in message ... I want to be able to add words to the end of a cell. For instance if the cell contains "total for NY", I want to be able to add " < 10,000" at the end. The cell would need to say "total for NY < 10,000". Then I want the whole row highlighted in yellow. Can someone please help me with this? Thank you CP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputbox Verbiage | Excel Programming | |||
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
How do I add verbiage to a cell that has a hyperlink already | Excel Discussion (Misc queries) | |||
Compare Text in 2 worksheets where verbiage is slightly different | Excel Worksheet Functions | |||
Macro to get rid of "Chart1" Verbiage | Excel Discussion (Misc queries) |