Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade Cells Yellows if Column (D) has a value of C in Cell
Please help me put together a macro that will search Column (D), starting in row 30 for a character 'C', if true then shade all cells in that row yellow between Column D and Column AC and strike through all values in that same range of Columns. Column D will have at the most one character in a row. Thanks so much for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shade Cells Yellows if Column (D) has a value of C in Cell
Sub highlightStuff()
For i = 30 To Cells(Rows.Count, 4).End(xlUp).Row If Cells(i, 4).Text = "C" Then With Range(Cells(i, 4), Cells(i, 29)) .Interior.ColorIndex = 6 .Font.Strikethrough = True End With End If Next i End Sub Dean P. wrote: Please help me put together a macro that will search Column (D), starting in row 30 for a character 'C', if true then shade all cells in that row yellow between Column D and Column AC and strike through all values in that same range of Columns. Column D will have at the most one character in a row. Thanks so much for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shade one cell that will shade multiple cells | Excel Discussion (Misc queries) | |||
How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) | |||
Trying to shade cells | Excel Programming | |||
Shade Active Cell - Shade the cell the cursor is in only while in | Excel Programming | |||
shade cells | Excel Discussion (Misc queries) |