Google Script App change color cells when a cell have a specific value
<p>I've been trying to look for what I need to do but I couldn't figure it out how to do this from the previous posts I found.</p>

<p>I have this Google Spreadsheet <a href="https://docs.google.com/spreadsheets/d/1hwmLLjvSfgNb0YD8sptdrjV_5N6tcleiO4q6j2gyQVM/edit#gid=593280854" rel="nofollow">here</a></p>

<p>Want I' love to do is to analize the data in the sheet called "actual" and set the background color of the cells when it meets a condition. So basically, I'm looking for a script to do this:</p>

<pre><code>get the data from the sheet called 'actual'
if a cell is error (equals to "#N/A") then set the color font to white
if a cell equals to "wnd" then set the background color to "red"
if the cell equals to "otc", then set the background color to "green"
etc..
</code></pre>

<p>It's going to have around 50 conditions and that is why I would love to do this with code instead of regular Conditional Formatting.</p>

<p>Thank you in advance.</p>