Changing the backcolor of a cell when data is added

  • Follow


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.
0
Reply Utf 2/18/2010 9:40:05 PM

I would recommend a Conditional Format

Select the cells you want to colour
Selet Format | Conditional Formatting...
Cell value is | Equal to | =""
Select Format and choose a blue background.
OK
-- 
HTH...

Jim Thomlinson


"OldPoplarPete" wrote:

> 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.
0
Reply Utf 2/18/2010 9:50:01 PM


1 Replies
246 Views

(page loaded in 0.034 seconds)

Similiar Articles:
















7/25/2012 7:46:44 AM


Reply: