Conditional Formatting Fill Color But Don't Change Font Color

[jock444]

Hi, I've got a combo box with 4 options that change the font color of a range of cells (to red, blue , green, or black) using conditional formatting. I want another option to add a yellow fill color to the same cells but I don't want the existing font color to change. In conditional formatting it seems you have to choose a font color as well as a fill color which is no good for me as I want to leave the text as it is. What would be the best way to solve this? I'm a bit of a novice so any help would be greatly appreciated.

 

[Special-K99]

As you say font colour needs to be specifed as well.

At a guess I would say VBA would be your only option though I'm no expert in VBA.

 

[jock444]

I'm now using a macro for fill color but it still wants to change the text color back to black instead of leaving the text as it is . Hoping someone can help me with this code:

Private Sub ComboBox1_Change()
    If ComboBox1.Value = "Blue Color" Then
          Range ("A1").Interior.Color = RGB(83, 141, 213)
    End If
End Sub

Is there some code I can add in to keep current font color (or add it back in after applying the fill color)?