You can customize the user interaction with individual cells (or a range of cells). You can use rules or conditional operators in the conditional format.

To customize this aspect of user interaction, you may perform the following tasks:

• Creating Conditional Formatting with Rules
• Conditional Formatting of Cells