Cell colour change on changing cell value
Closed
invent
-
Aug 12, 2009 at 02:15 AM
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 - Aug 13, 2009 at 04:50 AM
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 - Aug 13, 2009 at 04:50 AM
Related:
- Cell colour change on changing cell value
- Change computer name cmd - Guide
- Change lg tv name - Guide
- Crimping colour code - Guide
- How to change number of best friends on snapchat - Guide
- T-mobile change number - Guide
2 responses
kaiyasit
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Aug 12, 2009 at 06:04 AM
Aug 12, 2009 at 06:04 AM
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
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
kaiyasit
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Aug 13, 2009 at 04:50 AM
Aug 13, 2009 at 04:50 AM
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
and write VBA code to control when value change.
Do you have file example?
best regards,
Kaiyasit Phanmakorn
kaiyasitp@gmail.com
Aug 13, 2009 at 04:03 AM
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.