• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 643
  • 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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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