Comparing Two Values And Highlighting the trend in color?

[ramki]

Hi,

In excel i want to compare two values and indicate increase or decrease in the trend using color & bold

for example

Sep. (Revenue) - Oct. (Revenue)

100 - 200

Comparing the two values, if the october value is greater than september value then, the oct. value has to be shown in bold & green, like above one

If the oct value is less than september value then, the oct. value has to be shown in bold & red.

I am not a good programmer in vb. nor have good macro programming knowledge.

Please enlighten me, How to achieve this. Please Help!

 

[ktab]

Conditional formating:

Lets say that a1 is Sep b1 is Oct values
Select b1 cell
Go format->Conditional formating...

There, condition1:
Cell value, greater that, =$A$1
after that press Format... button.
At fond select Bold, and at same tab, color green.

Return to conditional formating window and press add>> button
goto condition2 tab
Same procedure, but now cell value, less that, =$A$1
e.c.t.