Automatically format cells (e.g. change font color) based on a certain condition? Use the conditional Formatting. Conditional formatting allows you to set rules for cell formatting. If the rules (conditions) are met, then the formatting is applied. To do this:

1. Select the cells to be formatted

2. On the [Home] tab of the ribbon click [Conditional Formatting]

3. Leave the first drop-down box set to ‘Cell Value Is’

4. In the second drop-down box, choose one of the operators. Example, choose ‘greater than’

5. In the text box, type a number or a cell reference. In this example, type the value you want to check – 499999.

6. Click the Format button

7. On the Patterns tab, select a colour for the conditional formatting — blue, in this example.

You can also choose a Font format or a cell Border.

8. Click OK.

9. To add another conditional format, click the Add button.

10. Repeat steps 3 to 8, using the values and colours for the second conditional format.

11. Click OK, to return to the worksheet.

More Under Finance

Posted Under

Category : Finance (3656)
Type : Articles (16711)
Tags : Excel Tips (35)

0 responses to “Excel Tips – How to Automatically format cells (e.g. change font color) based on a certain condition?”

  1. Anil Mathews says:

    Your Excel tips each per day is a good work, helpful and much apreciated.

Leave a Reply

Your email address will not be published. Required fields are marked *