Conditional Formatting for Google Sheets with Apps Script

Question

https://docs.google.com/spreadsheets/d/1vpfzR2rm0P-LW_AC7lSe2HmuL_IKrK1XOnJ0R64xXXM/edit?usp=sharing

I'm trying to figure out how to use apps script to make the repetive number highlighted in yellow either disappear or put a white background and white text so that it isn't visible all the way down. I've tried setting custom formula in conditional format but kept getting error messages.

Answer 1

As far as I can understand your table, you need to add a condition IF:

=IF(E20<>"",sum(G19,E20-F20),"")

It will put into cell figures only if next cell is not empty.