Tutoring computer use, you might talk about conditional formatting with Excel. The tutor mentions a quick example.
You can make up your own condition that causes cells to format specifically. It might be done, more or less, like so:
Let’s imagine you want to format all cells in the range f3:f10 so that values above 70 appear in green. You would select that range.
Next, on the Home panel, you can click Conditional Formatting, then click New Rule. A list of choices is shown, at the bottom of which is “Use a formula to determine which cells to format”. Clicking that option, you’ll see a label “Format values where this formula is true”.
In the box, key in =f3>70. Next, click the Format button.
Various fonts and effects are offered. The Color option, under the Font tab, appears at centre right, and might be easy to miss; it’s a drop-down menu.
After selecting the effects and colors desired, one has to click OK a couple of times to invoke the conditional formatting:)
Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.