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<\/span> screen, The icon appears in the Styles<\/span> group, perhaps to the right of center.<\/p>\n For our example, you’d click Conditional Formatting<\/span>, then New Rule…,<\/span> then In my experience, Excel’s between<\/span> is inclusive; therefore, if you signify that numbers between 78 and 93 should be green, 78 will be.<\/p>\n HTH:)<\/p>\n Source:<\/p>\n Microsoft Office support<\/a><\/p>\n
Format only cells that contain<\/span>; a dialogue box will appear. In it, you’ll see a choice box where between<\/span> 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…<\/span> button which you can click to set specific text attributes. The Color<\/span> drop-down menu may say Automatic<\/span>; 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<\/span> button in both pop-ups to apply the conditional format.<\/p>\n