Nine things everyone should know how to do with a spreadsheet

By Rob Griffiths, Macworld |  Enterprise Software

Now do the same thing again, starting with the plus-sign click. But this time, set the text box entry to Stock OK, set the font color to green, and make sure the font style is normal, not bold. When you get back to the Manage Rules window, you should see both rules listed; click OK to (finally!) apply the rules.

Numbers: Select the range of cells (G2:G8), then click the Conditional Highlighting button on the Cell tab of the Format sidebar. This will change the sidebar; click the Add A Rule button to display a pop-up list of rules, then click the Text tab. Click the Is entry, set the first pop-up to Text Is, and type Order Soon! in the box. Click the triangle in the menu below the text entry box, and select the final entry, Custom Style.

This will add yet another panel to the sidebar; select a red tone in the color wheel, and click on the B button for bold text. Finally, click Done.

That formats the Order Soon! cells. But what about the Stock OK messages, which are presently just black text? With the G2:G8 range still selected, click Show Highlighting Rules in the sidebar, then click Add a Rule again. Repeat the steps as above, except change the text box to read Stock OK, and set the custom style to have nonbolded green text. Click Done, and you'll see both bold red and normal green text in the cell.

Sheets: Select the G2:G8 range, then select the Format > Conditional Formatting menu item. In the dialog box that appears, set the first pop-up to Text Contains, then type Order Soon! in the text box. Check the Text box to format the text, then click the next seemingly empty box to the right in order to display the color picker; choose a nice shade of red. You might also want to check the Background box and set a background color (bright yellow will get your attention), because Sheets doesn't let you alter the font's appearance with conditional formatting.

Click the Add Another Rule link, and repeat the steps, but type Stock OK in the text box, and use green for the text color. After you've set up the second rule, click Save Rules to see the results of your work.


Originally published on Macworld |  Click here to read the original story.
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Answers - Powered by ITworld

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Ask a Question