Coloring One Cell in a Datasheet Subform

How to make one cell in a datasheet subform a different color than the others using conditional formatting.

Q:  Rosie W. writes to ask if there is any way to make one cell in a datasheet subform a different color than the others.  This control is locked, and she wants it to be a different color to make that obvious to the users.

A:  Yes, this can be done with conditional formatting.  Select the locked control, right-click it and select Conditional Formatting from the context menu.  Select “Expression Is” in the Conditional Formatting dialog, and enter an expression that will always evaluate to True, such as 1 = 1.  Select the color you want the control to be, and click OK.  Now this cell of the datasheet will always be the selected color. 

You can also create a condition that will color the cell only if the condition is met, such as making the cell a certain color if the value of a field is over a certain amount.