Skip to main content
edited tags; edited title
Link
ale
  • 52.9k
  • 42
  • 165
  • 314

Conditional formatting for a single cell based on a row being empty or containing any values [google sheets]

Source Link

Conditional formatting for a single cell based on a row being empty or containing any values [google sheets]

I want A1 to go green if any cells in range B1:J1 contain any values.

A1 to remain blank if B1:J1 contain no values.

In the sheet all values will be text based but will vary from cell to cell.