By default, Google chooses a scale from green to CANADA B2B List white. But you can adjust this. Under Formatting Rules, click the preview to see options. In the case of the expenses, I choose the ‘Green to White to Red’ option. But in another situation, you might want to choose ‘Red to White to Green’ or ‘Red to Yellow CANADA B2B List to Green’. You can also choose a minimum and maximum and a midpoint. Click done and you’ll see how your spreadsheet indicates which expenses were low and which weeks were very expensive (red!). You can also set this for the income, but then CANADA B2B List you have to choose the color scale the other way around. Set color scale for marketing planning.
Collected Her CANADA B2B List
Automatically display the current date This tip can be CANADA B2B List useful if you keep a content schedule in your spreadsheet. Select the column or row where you want to apply CANADA B2B List this. This should be a row/column where you keep data. For example, every day of the year. Under Conditional formatting rules, choose ‘Format cells as in the drop-down menu for ‘Date is’ and ‘Today’. Choose a handy color in the layout style, so that CANADA B2B List you can easily see what day it is in your spreadsheet. And voila! Set today’s date with conditional formatting.
Favorite Free Tools CANADA B2B List
Using your own dropdown lists I use this tip a lot CANADA B2B List myself. Suppose you have created a content schedule for your social channels in a spreadsheet with a few colleagues. For each post, you also want to note which of the colleagues makes and schedules this post. You can manually enter names in a separate CANADA B2B List column each time… but you can do that more efficiently with a dropdown list! Create a column in a separate tab in your CANADA B2B List spreadsheet, in which you enter all the names of your colleagues. These can be full names, but abbreviations allow you to narrow the column and save space. Go to the tab where you want to use such a dropdown list. Select the column or row where you want to make it and right click.
