Conditional Formatting - BOLDING

S

Sue Compelling

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
Word doc keeps changing to ALL CAPS 0
Keep First Letters, with exceptions 0
Improving Macro That Keeps First Letter 0
Conditional Format Using If 2
Conditional Formating: MAX & MIN 3
conditional format truncates memo field 1
Word isn't capitalizing the first word of each sentence 2

Top