CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-sheets-formula
Mitchell Bivens
Mitchell Bivens

Reputation: 99

Conditional Formatting for Google Sheets with Apps Script

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.

Upvotes: 1

Views: 116

Answers (1)

Yuri Khristich
Yuri Khristich

Reputation: 14537

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.

Upvotes: 1

Related Questions