How to Apply a Color Scale Based on Values in Google Sheets

With conditional formatting, you can apply a two- or three-color scale quite easily. Plus, you can take advantage of the preset color gradients or use your own custom colors. We’ll show you how to do both.

Apply a Quick Conditional Formatting Color Scale

If you want to quickly apply a color scale in Google Sheets, you can use one of the nine presets. Select the cells that you want to format by clicking the first cell and dragging through the rest. Then, head to Format in the menu and choose “Conditional Formatting.”

Click Format, Conditional Formatting in the menu

This opens the Conditional Format Rules sidebar, where you’ll set up everything that you need. At the top of the sidebar, click the Color Scale tab. You’ll immediately see your selected cells with the default color scale applied. This gives you a nice example of how your data will look with the gradient.

Click the Color Scale tab

In the Apply to Range box, confirm the cells that you want to format and make edits if necessary.

Confirm or edit the cell range

Then, to use a preset, click the color scale below Preview. Here, you’ll see your nine gradient options. You can try out each option if you like by selecting one and then viewing your data.

Choose a preset color scale

By default, the values use minimum and maximum for the color scale without a midpoint, but you can adjust these values in the next area. You can choose a number, percent, or percentile for each and include the midpoint if it applies. Then, type in the values for these other options in the boxes to the right.

Adjust the values

When you finish setting up your rule, click “Done” at the bottom of the sidebar.

Click Done

Create a Custom Conditional Formatting Color Scale

Maybe you’d like to use specific colors for your scale. It could be your school colors or those in your company logo. Google Sheets lets you tailor the color scale exactly as you like. You’ll follow the same steps to set up your formatting rule. Select the cells, click Format > Conditional Formatting from the menu, and confirm the cell range in the sidebar.

Click the color scale below Preview and this time, choose “Custom Color Scale” at the bottom. To get a head start, you can choose a preset as the base for your custom scale.

Click Custom Color Scale

the right of each value, Minpoint, Midpoint, and Maxpoint, use the color button to display the palette. You can select a color or click “Custom” at the bottom. Then, enter a Hex code or use the slider and shade tool for the color that you want.

Choose a color or create a custom color

When you finish, click “Done” at the bottom of the sidebar to apply the rule.

Click Done

Whether you use a preset or a custom color scale, the conditional formatting rule adjusts if you change your data. So, when you make edits, the formatting accommodates those changes.

Color scale changes to data

If you want to apply your color scale rule to additional cells in your spreadsheet, you can copy the formatting in Google Sheets easily.

[mai mult...]

How to Disable and Remove the Microsoft Edge Math Solver

At the time of writing in June 2021, “Math Solver” is still in the Preview stage and is available by default in Microsoft Edge 91. When you click on it, a sidebar opens on the right side to let you clip and drop math formulas or type one in there.

If you don’t want the feature, however, you can hide the Math Solver button from the toolbar or disable it entirely. To simply hide the button, first, launch Microsoft Edge on your computer. Right-click the Math Solver icon in the top-right corner of the toolbar and select “Hide from Toolbar.”

To disable Math Solver in Microsoft Edge, we’ll use the Edge “flags,” which are just like the Chrome flags. Since it’s available as a flag, the feature is still a work in progress. That being said, removing it could impact your browser’s performance. Disable the flag at your own risk.

First, open Microsoft Edge on your computer. Type edge://flags in the address bar and hit Enter. You’ll now see the “Experiments” page. Type “math solver” in the search bar at the top.

type "math solver" in the search bar at the top on the Experiements page.

The “Math Solver in Microsoft Edge” item will show up in the “Available” section. Click the drop-down box and select “Disabled.”

Open the drop-down next to the "Math Solver in Microsoft" flag and choose "Disabled."

Select the “Restart” button in the bottom-right corner of the tab that pops up.

Select the "Restart" button in the bottom-right corner of the tab that pops up.

After that, the Math Solver icon won’t be visible when you open “More Tools” after clicking the ellipses menu (three dots) in the top-right corner.

[mai mult...]

How to Get Workbook Statistics in Microsoft Excel

Get Workbook Statistics in Microsoft Excel

You can view your Workbook Statistics at any point in your spreadsheet creation process, and as many times as you like. Open your Excel workbook and head to the Review tab. Click “Workbook Statistics” in the Proofing section of the ribbon.

Click Workbook Statistics on the Review tab

When the small window opens, you’ll see data for your current sheet at the top and the entire workbook at the bottom.

Workbooks Statistics in Excel

If you want details for a different sheet in your workbook, close the Workbook Statistics window by clicking “OK.” Then click the tab for the sheet that you want to see and follow the same steps listed above.

Workbooks Statistics for two sheets

Data Included in Workbook Statistics

You can see a decent amount of data with the Workbook Statistics feature. This is helpful for situations where you expect to see something in your current sheet or workbook and you don’t, or vice versa. Statistics differ slightly between the spreadsheet and the entire workbook. Also, keep in mind that most are simple counts (numbers).

Spreadsheet Statistics:

  • The end of the sheet (the last cell with data)
  • Cells with data
  • Tables and PivotTables
  • Formulas
  • Charts
  • Images and objects
  • Form controls
  • Comments and notes

Workbook Statistics:

  • Number of sheets
  • Cells with data
  • Tables and PivotTables
  • Formulas
  • Charts
  • External connections
  • Macros

You can view Workbook Statistics in Excel for Microsoft 365 on Windows and Mac as well as in Excel on the web. You can also access it in the same way on these platforms. The only difference is that Excel online does not display the complete data lists written above for sheets and workbooks.

[mai mult...]