Office Watch

Office 2013

Office Mobile / iPad

Office 2010

Office 2007

Office 2003

Office XP

Office for Mere Mortals

Access

Email

Buying Office

Office 365

Winks

Office News Wire

Join us!

Our Ebooks

Mobile | PDA

RSS


Search

Command Finder


Microsoft Office Bookshop

About

Home




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.

by Access Watch

Bookmark and Share

  | Mobile | click for more article services     


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.

Office 2013: the real startup guide

OFFICE 2013: the real startup guide Everything you need to know about Office 2013 but Microsoft won't tell you.

How to save money, install, configure and use the new features in Office 2013.  Get it today - click here.

Windows 8 for Microsoft Office users

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.



Article Services sponsored by: Office Watch Ebooks - available now to download and read today.
RSS feed for this category Subscribe

Translate | Mobile | Links
 Add to: Bookmarks | | DiggThis | Yahoo! My Web


New & Popular
» Office Online update
» Deleting Holidays
» Office Online in Google Chrome
» Windows 8.1 Update – secret changes list?
» Missing Easter from Outlook
» Ignore or Mute emails in Outlook


Office Watch, Office for Mere Mortals, Access Watch and all titles used within the publications are Copyright © 1996-2014 Office Watch.
Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft Powerpoint and doubtless many other names are registered trademarks of Microsoft Corporation.

Search  |  Sitemap |  Popular Topics | Privacy Statement |  Advertising |  Twitter |  Feedback / Contact Us
Office Watch is definitely not affiliated with Microsoft - and that's just one reason why we are so useful to Microsoft Office users around the world J (Erko).