There are two basic kinds of conditional formatting. If you select Conditional Formatting from the Format menu, the Conditional Formatting dialog defaults to the syntax, where you specify that the Cell Value Is. For example, you might set up a conditional format where the Cell Value is less than 0. The other syntax is far more powerful. The Formula Is syntax allows you to build any formula or function that evaluates to True or False. This formula may point to cells other than the current cell, or it may combine multiple conditions with the OR or AND function. You can combine up to three different conditions for each cell.
Was this article helpful?