LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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 ***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the background color of cells once it being edited shawn lee Excel Programming 0 September 15th 08 06:12 AM
change background color in cells Joe Excel Worksheet Functions 4 November 6th 07 11:20 PM
I want to change the background color of cells, if value is a square root. George C. Excel Programming 1 December 9th 06 06:29 PM
How do I change a merged Cells background color rich Excel Programming 0 October 25th 06 03:33 PM
Change font and background color of several cells based on result of a formula Zenaida Excel Discussion (Misc queries) 2 April 27th 06 06:46 PM


All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"