Changing Fill Color When Data is Entered

  • Thread starter Thread starter Julia1727
  • Start date Start date
J

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
 
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
 
Back
Top