Changing Fill Color When Data is Entered
 

What I'm looking for is how to start with the group of cells greyed until I
input any data into the cell, and when every cell is completed the last
column in the row turns back to white

Changing Fill Color When Data is Entered
 

I selected F1:F10 and used the command Format | Conditional Formatting
IN the CF dialog I set it to: Formula is =COUNT($F1:$F$10)<10 and then
clicked the Format button on the dialog, opened the Pattern tab and set a
colour.
Now the range F1:F10 has a coloured fill until I fill every cell with a
number
If your data is text then use COUNTA in place of COUNT
Doest this help?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Julia1727" wrote in message
...
What I'm looking for is how to start with the group of cells greyed until
I
input any data into the cell, and when every cell is completed the last
column in the row turns back to white