How to color-fill blank cells, then once data is entered cell is no-fill

**hatemail13** · 03-28-2013, 07:25 PM

I've been trying to look online but none of the tuts are really helping me. I am using Microsoft Excel 2010

I'm trying to format my spreadsheet. I have a Gross Rate column and a Net Rate column (about 100 rows).

I want to format the spreadsheet so that if there is nothing at all entered in the cells, the cell will be filled with a color. As soon as any data is typed into that cell, I want the cell's fill to be blank (so white).

I've seen this on other spreadsheets but do not know how to accomplish this.

Thank you very much

**FDibbins** · 03-28-2013, 07:33 PM

You can do this with Conditional Formatting.

Your profile says you have 2003, I cant remember exactly where CF is in that ver. but it should be under formatting (i think)

You need to go into CF and select "format cell contents" and select "blank" if that option is there

**hatemail13** · 03-28-2013, 07:34 PM

Whoops havent updated this profile in a long time....I'm using 2010 at work

**FDibbins** · 03-28-2013, 07:37 PM

ok same thing...

select the range you want to apply CF to
find CF on the Home tab - styles
select New Rule
select "format cells that contain"
on the pull-down, select BLANKS

**hatemail13** · 03-28-2013, 07:43 PM

Originally Posted by FDibbins

ok same thing...

select the range you want to apply CF to
find CF on the Home tab - styles
select New Rule
select "format cells that contain"
on the pull-down, select BLANKS

Got it thank you very much!!! Works fine!

**FDibbins** · 03-28-2013, 07:57 PM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)