Excel: Conditional Formatting, part II

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:)

Source:

support.office.com

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Leave a Reply