Is there a way to change a cell color based on wether or not other cells have content?
Something like
(if any cell in cell range A1-X200 is not empty, then cell X201 is green fill)
(else X201 is no fill)
Thanks!