I would like to apply conditional formatting to a selection of data.

enter image description here

From cell "D2" (and beyond), cells should be shown in green if it is greater than or equal to cell C2 (and below).

Some examples:

  • D2 shouldn't be green
  • E2 should be green
  • D9 should be green
  • G9 shouldn't be green

How can I make this happen?

The google sheet can be found here.

1 Answer 1


Use this formula into the conditional formatting of D2:G


To prevent cells D2:G from turning green if filled in when the cells in column C are still empty, use this one:


Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.