Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 630
  • Last Modified:

Access conditional formatting set fill colour

I want to be able to set the conditional formatting - Fill/Back Colour on a text box. The selection of colours is limited and I am looking for a lighter colour of red. Is there anyway to add colours to the selection?
0
Idarac
Asked:
Idarac
  • 2
  • 2
1 Solution
 
Rgonzo1971Commented:
HI,

When you are creating a Formatting Rule underneath the Standard Color by thee Fill button you can choose More Colors

Regards
0
 
IdaracAuthor Commented:
Sorry but I don't see it
0
 
Dale FyeCommented:
You can use the form Open event to run code similar to

With forms("forms1").Controls("Textbox1").FormatConditions(1)
    .BackColor = RGB(255,255,255)
    .FontBold = True
    .ForeColor = RGB(255,0,0)
End With
0
 
Rgonzo1971Commented:
Hi,

In Design Mode right-click your textbox Choose Conditional Formatting add a new rule or edit one
then Click the Fill button to choose your color.

Regards
0
 
IdaracAuthor Commented:
Thank you
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now