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. |
Changing the backcolor of a cell when data is added
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. |
All times are GMT +1. The time now is 04:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com