title: In Google Spreadsheets, how to ignore empty cells in conditional formatting?
body: <p>I'm trying to format a spreadsheet to change cell color to green/red if the result was predicted correctly/incorrectly. For the correct one, I just went with =(cell with the results)=(cell where the prediction is) and it's all fine, but for the incorrect ones, I had to do NOT(same formula I just wrote) and it tries to color every cell red, even those that haven't had a prediction typed in yet, because there can be multiple bad outcomes. How to ignore conditional formatting before the result is typed into the &quot;result&quot; cell?</p>