Changing the backcolor of a cell when data is added

  • Thread starter Thread starter OldPoplarPete
  • Start date Start date
O

OldPoplarPete

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.
 
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
 
Back
Top