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

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!