Cell colour change on changing cell value
Closed
invent
-
12 Aug 2009 à 02:15
kaiyasit Posts 30 Registration date Sunday 9 August 2009 Status Member Last seen 20 April 2010 - 13 Aug 2009 à 04:50
kaiyasit Posts 30 Registration date Sunday 9 August 2009 Status Member Last seen 20 April 2010 - 13 Aug 2009 à 04:50
Related:
- Cell colour change on changing cell value
- How to change text colour html - Guide
- Change lg tv name - Guide
- How to change computer name - Guide
- Rj45 colour code - Guide
- Idm language change - Guide
2 responses
kaiyasit
Posts
30
Registration date
Sunday 9 August 2009
Status
Member
Last seen
20 April 2010
12
12 Aug 2009 à 06:04
12 Aug 2009 à 06:04
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 9 August 2009
Status
Member
Last seen
20 April 2010
12
13 Aug 2009 à 04:50
13 Aug 2009 à 04:50
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
13 Aug 2009 à 04:03
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.