If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting
Here is my request. I have a form with a drop down menu
of 4 items. I am trying to write a formula (not code) for the following action: =IIF[Classification]="Protected B", [Name]= (Colour of font will be white). I don't seem to be able to make it work. I am always missing something. What I really want is that some field would look like empty if the classification is Protected B. Can anyone help me on that formula^ Thanks a bunch |
#2
|
|||
|
|||
Hello,
I think you have to use VBA code. For example, add following code behind the afterupdate event of the combo box. It changes the backcolor of customerID field on a form to white if you select "alfki" from a combo box: If Me.Combo45 = "alfki" Then Me.CustomerID.BackColor = 16777215 Else Me.CustomerID.BackColor = 13434879 End If Regards, Ki Yi Microsoft Support This posting is provided AS IS with no warranties, and confers no rights. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |
Pivots and keeping conditional formatting | Jenn | General Discussion | 1 | August 11th, 2004 10:35 PM |
Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |
Greater than formulas with conditional formatting | Jamie | New Users | 1 | May 21st, 2004 04:32 AM |
Conditional Formatting on a cell that has an IF function | DDM | Worksheet Functions | 0 | May 11th, 2004 05:13 PM |