Both amount and variance
Now let's highlight the percentage variance only if it is over 10% and the associated dollar variance is over $1,000.
We will not add in the negative variances so that we can focus on the structure of the AND function.
この演習はコースの一部です
Google スプレッドシートの条件付き書式
演習の手順
- Add a conditional formatting rule that uses a custom function that applies formatting to the range
E8:E20and highlights a cell with the Default green background if the value in columnDis greater than $1000 and the value in columnEis greater than 10%.
