Pay allowed range
While we're on the subject of PTO, it's nice to have a sense of the range of PTO that each employee has accumulated.
Let's format the values in the PTO Total column in a way that illustrates the values with degrees of color instead of just numbers.
この演習はコースの一部です
Google スプレッドシートの条件付き書式
演習の手順
Add a conditional formatting rule, using the Color scale option, to the
PTO Totalcolumn.Switch the color from "Green to white" to "White to green", which is right below it.
