Drop-down menu

Consider the workaround below instead:

 

1. Use Conditional Formatting

You can mimic formatting behavior by applying conditional formatting rules based on the selected value:

• Go to Home > Conditional Formatting > New Rule
• Use a formula like:

=A1="High Priority"

 

• Set the desired font color or style

2. Use VBA for Dynamic Formatting

If you want to apply the exact formatting from the source list, you’ll need a VBA macro:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim sourceList As Range
    Set sourceList = Sheets("Lookup").Range("A1:A10") ' Adjust to your list range

    If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
        Dim cell As Range
        For Each cell In sourceList
            If cell.Value = Target.Value Then
                Target.Font.Color = cell.Font.Color
                Target.Font.Bold = cell.Font.Bold
                Exit For
            End If
        Next cell
    End If
End Sub

 

• Place this in the worksheet code module where the drop-down is used
• It copies font color and bold style from the source list