Solved How do I create an Excel 2010 Macro to change font color?

November 20, 2015 at 16:58:12
Specs: Windows 7
I'm using a radio button to make a selection on a spreadsheet but when I use the cell link feature the 1.00 or 2.00 turns white in a light grey cell. I'm trying to make the 1.00 / 2.00 the same color as the cell.

Also, I want to run this macro in the loop from row number 6 to 128.

Any ideas?

See More: How do I create an Excel 2010 Macro to change font color?

Report •

November 30, 2015 at 00:36:12
Do you have a macro already or are you wanting us to create one for you? if you need us to help make one then please provide more detail, what is the purpose of this macro exactly? what is the process you want to follow before the macro is triggered?

a lot more information is needed.

Report •

November 30, 2015 at 13:01:35
✔ Best Answer
As AWTL said, we probably need more information.

Just as a shot in the dark, you might try the following code.

Assuming the cell that is changed is in Rows 6-128 and the cell has a fill color, the font color will be set to match the fill color.

Private Sub Worksheet_Change(ByVal Target As Range)
 Select Case Target.Row
   Case 6 To 128
    Target.Font.ColorIndex = Target.Interior.ColorIndex
 End Select
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question