LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Changing the backcolor of a cell when data is added

I want to automatically change the colour of a cell in Excel when data is
added to that cell. For example: an empty cell has a blue backcolor when a
number is put into the cell the background automatically changes to white.
 
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
Changing cell addresses to recently added names in existing formul Colts41 Excel Worksheet Functions 3 September 10th 08 07:31 AM
Changing BackColor on Command Buttons? RBee Excel Discussion (Misc queries) 1 August 30th 06 02:32 AM
pivot chart colors- how to keep from changing when data elements are added/removed? KR Charts and Charting in Excel 1 July 12th 06 06:41 PM
How do I keep a formula from changing if a row is added or deleted cwolt Excel Discussion (Misc queries) 1 December 27th 04 11:18 PM
How do I keep a formula from changing if a row is added or delete. cwolterman Excel Discussion (Misc queries) 1 December 27th 04 09:13 PM


All times are GMT +1. The time now is 07:52 AM.

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"