colour coding (xp)

Topic

New Reply

I have a subform which I am trying to set each row colour based on whait is in the status column. If “On hold” the row should be red; “In pro” the row should be yellow; and ” completed” the row should be Green. I have tried the conditional formating but something went wrong.

Reply | Quote

Replies

The Status field is a number (long integer). The combo box has 2 columns, of which the first (hidden) one contains the numeric ID, and the second one displays the corresponding description from the Status table. So for “On Hold”, you should test for the value 1, etc. – see the Status table. And you should use Value Is, not Expression Is.

Does that give you enough to solve the problem?

Reply | Quote

But how do I get it to do the entire row not just the cell?

Reply | Quote

Open the form in design view.
Select all text boxes/combo boxes.
Select Format | Conditional Formatting.
Select Expression Is from the dropdown (yes, this time you need it)
Enter [Status]=1 in the box next to it.
Select red as background color and white as font color.
Click Add >>, and repeat for the other two values.
Click OK.

Reply | Quote