Applying Simple Conditional Formatting

Here are the steps for applying conditional formatting of the type:
“If a cell is equal to something (could be a word or a numeric value), then give it a certain color”.

1. Select the relevant range of cells. (by the way, you can apply the rule to a single cell too).

2. Click the Conditional Formatting button, and choose the first option (“Highlight Cells Rules”).

3. Choose “Equal To…”

4. Type the certain value (that if exists will become formatted).

5. Choose the color from the drop down menu on the right.
(You can also choose “Custom Format…” and then from the “Fill” tab choose a specific color, or from the “Font” tab choose a specific format such as bold, underline, font color etc.).

6. Click OK.