If you wish to change the format of cell based on the value in a cell, You do not need to use a macro to change the cell format automatically. You just need to know the features of microsoft excel.

What is the features?

The feature is conditional formatting. To understand the feature you can see the following simple example.

Under format menu, select conditional Formatting

When the first Conditional Formatting window appears, enter first condition. In this example Formula is =OR($C3=”",$C3=”0″, $C3=”Right”). Next, you need to select what formatting to apply when the condition is met. To do this, click on the Format button.

In the font tab you can set the font style and font color

For the cell background color or style you can choose Pattern tab. In order to understand the detail see the following picture.

You can add conditions to the conditions 1 to 3 in accordance with your wishes. As in the example you can notice the following condition.

Now when you return to the spreasheet, the conditional formatting will be applied. As you can see in the following sample.