Let's say I have a Google Sheet where A1 needs to be filled green when B1 till B7 has been filled in with no matter what; and A1 needs to be red when 1 or more cells from B1 till B7 are not filled in yet.

Would this be possible in Google Spreadsheets?

  • Is google spreadsheet a replacement for the all powerful MS Excel? I'm really surprised to see so many questions on google apps
    – Prasanna
    Commented Oct 26, 2014 at 15:48

1 Answer 1


Fill A1 red (normal fill) and apply a Conditional formatting rule of Custom formula is :


with green Background Colour and Range: A1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.