Cell colour change on changing cell value

Closed
Report
-
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
-
Hello,
How can i select the colour for a specific cell with reference of cell value change.
Suppose Cell value is greater then previous value show one colour and again the new value is low then previous value it show onther colour.

Can it be in Exchel Sheet or .........

2 replies

Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Use ConditionFormating by

On menu bar click
1.Format
2.Condition Formatting
you will see.....2 types that is
1.Cell Value is
2. Formula is

Please try...........

Best regards,
Kaiyasit Phanmakorn
kaiyasitp@gmail.com
0
Boss,

I tried it. But I want colour change of the same cell. If value change of it. Suppose A4 has value 4 & after few second it change 5. What formula I have to fit there.
0
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Try to use "Sub Worksheet_Change(ByVal Target As Range)"

and write VBA code to control when value change.

Do you have file example?

best regards,
Kaiyasit Phanmakorn
kaiyasitp@gmail.com
0