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.
Article posted: Wednesday, 06 June 2007
there's more ...
If you liked this article you'll LOVE our new ebooks.
Windows 8 for Microsoft Office users A practical guide the new, changed and unfamiliar in Windows 8
A focused and unvarnished look at Windows 8, especially written for
the many people who use Microsoft Office Get it today
- click here.
ORGANIZING OUTLOOK EMAIL - tame your Outlook 2010 Inbox
100+ pages of practical tips and help to streamline,
automate and search your Inbox. Get more
than you ever thought possible from Outlook. Read it today
- click here.