Conditional Formatting - BOLDING

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi -

Using the posts in here I've been able to get my conditional formatting to
work to change colours - though I can't get it to work with BOLDING the text.
Here's my code - what am I doing wrong?

Select Case Me.Lights
Case "*"
Me.Lights.ForeColor = 255
Me.Trust.ForeColor = 255
Me.Trust.FontWeight = Bold
Case "**"
Me.Lights.ForeColor = 33023
Me.Trust.ForeColor = 33023
Me.Trust.FontWeight = Bold
Case "***"
Me.Lights.ForeColor = 0
Me.Trust.ForeColor = 0

TIA
 
Back
Top