ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change the background color of cells once it being edited (https://www.excelbanter.com/excel-programming/417120-re-change-background-color-cells-once-being-edited.html)

Shawn lee

Change the background color of cells once it being edited
 


Hi,

It works, but what I want is when some changes is made then it change
the cell background color. For this code, if for example the original
value in the cell is 1 then if you type 1 into the cell again, it
changes color.

Do you have something where by if you key 1 in it, it wont change color
but when you key something else maybe 2 or 100 then it changes color.

Anyway its already a big step forward. Thanks dude

*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 05:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com