[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!

[markajm]

no need for macro's or vb progs.

on the menu bar --> format --> conditional formatting