Somebody asked this question, and so I wanted to show how to do it here. It is really simple.
As you may know, when you change the color for 1 row in a continuous form, every row will be affected! Not like Excel.
So how do you fix this?
Glad you asked…with VBA and conditional formatting.
So take a look….
1. Add a blank text box to your continuous form, and call it something like “txtBlank”.
2. Then add some VBA code to the current event of the form like this:
Private Sub Form_Current()
Me.txtBlank = Me.CustomerID
3. Then just add some conditional formatting to change the background color of the text box when the current row is clicked:
When the Expression is [CustomerID]=[txtBlank] set the background to some color.
Just add the conditional formatting to the other fields and hide your blank field and you are good to go.
Let me know if you have any questions.