Comparing Two Values And Highlighting the trend in color?

ramki

New Member
Joined
Oct 13, 2006
Messages
23
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!
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

ktab

Well-known Member
Joined
Apr 21, 2005
Messages
1,297
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.
 

Forum statistics

Threads
1,136,924
Messages
5,678,598
Members
419,774
Latest member
MooseWinooski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top