The tutor opens the discussion about how to display, automatically, a cell’s content according to its value.

What if, in Excel, you want to display any value between 78 and 93 in green? Well, you can, using conditional formatting. On the Home screen, The icon appears in the Styles group, perhaps to the right of center.

For our example, you’d click Conditional Formatting, then New Rule…, then
Format only cells that contain; a dialogue box will appear. In it, you’ll see a choice box where between can be selected; just to the right you can enter the lower and upper limits (in our case, 78 and 93). You’ll see a Format… button which you can click to set specific text attributes. The Color drop-down menu may say Automatic; you’ll have to click the arrow to see the color choices, then click the one you want. Afterwards, you’ll have to click the OK button in both pop-ups to apply the conditional format.

In my experience, Excel’s between is inclusive; therefore, if you signify that numbers between 78 and 93 should be green, 78 will be.

HTH:)

Source:

Microsoft Office support

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