Posts

Showing posts from November, 2022

Use conditional formatting rules in Google Sheets

-
Image
  Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number. On your computer, open a spreadsheet in  Google Sheets . Select the cells you want to apply format rules to. Click  Format     Conditional formatting . A toolbar will open to the right. Create a rule. Single color : Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met. Color scale : Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow  . Click  Done . Example A teacher can highlight test scores to see which students scored less than 80%. On your computer, open a spreadsheet in  Google Sheets . Select the test scores. Click  Format     Conditional...
Post a Comment
Read more

Excel Max Function

-
Image
  MAX function in Excel: formula examples to find and highlight highest value Excel MAX function The MAX function in Excel returns the highest value in a set of data that you specify. How to make a MAX formula in Excel To create a MAX formula in its simplest from, you can type numbers directly in the list of arguments, like this: =MAX(1, 2, 3) In practice, it's quite a rare case when numbers are "hardcoded". For the most part, you will deal with ranges and cells. The fastest way to build a Max formula that finds the highest value in a range is this: In a cell, type  =MAX( Select a range of numbers using the mouse. Type the closing parenthesis. Press the  Enter  key to complete your formula. For example, to work out the largest value in the range A1:A6, the formula would go as follows: =MAX(A1:A6) If your numbers are in a  contiguous  row or column (like in this example), you can get Excel to make a Max formula for you automatically. Here's how: 1- Select th...
Post a Comment
Read more