Changing Fill Color When Data is Entered

[Julia1727]

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

 

[Bernard Liengme]

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