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.