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

DATA FILTER IN EXCEL

-

Filtering data

Filters can be applied in different ways to improve the performance of your worksheet. You can filter text, dates, and numbers. You can even use more than one filter to further narrow your results.

  1. 1- Begin with a worksheet that identifies each column using a header row.
    Worksheet with header row
  2. 2- Select the Data tab, then locate the Sort & Filter group.
  3. 3- Click the Filter command.
    Clicking the filter command
  4. 4- Drop-down arrows will appear in the header of each column.
  5. 5- Click the drop-down arrow for the column you want to filter. In this example, we'll filter the Type column to view only certain types of equipment.
    Filtering a column
  6. 6- The Filter menu appears.
  7. 7- Uncheck the boxes next to the data you don't want to view, or uncheck the box next to Select All to quickly uncheck all.
  8. 8- Check the boxes next to the data you do want to view. In this example, we'll check Laptop and Projector to view only these types of equipment.
    Selecting filter data
  9. 9- Click OK. All other data will be filtered, or temporarily hidden. Only laptops and projectors will be visible.
    Filtered worksheet
  10. Filtering options can also be found on the Home tab, condensed into the Sort & Filter command.

To add another filter:

Filters are additive, meaning you can use as many as you need to narrow your results. In this example, we'll work with a spreadsheet that has already been filtered to display only laptops and projectors. Now we'll display only laptops and projectors that were checked out during the month of August.

  1. 1- Click the drop-down arrow where you want to add a filter. In this example, we'll add a filter to the Checked Out column to view information by date.
  2. 2- Uncheck the boxes next to the data you don't want to view. Check the boxes next to the data you do want to view. In this example, we'll check the box next to August.
    Selecting filter data
  3. 3- Click OK. In addition to the original filter, the new filter will be applied. The worksheet will be narrowed down even further.
    Worksheet with two filters

To clear a filter:

  1. 1- Click the drop-down arrow in the column from which you want to clear the filter.
  2. 2- Choose Clear Filter From.
    Clearing a filter
  3. 3- The filter will be cleared from the column. The data that was previously hidden will be on display once again.
  4. To instantly clear all filters from your worksheet, click the Filter command on the Data tab.

Comments

Post a Comment

Popular posts from this blog

HLOOKUP Function in Excel With Example

-
Image
  HLOOKUP in Excel – With Examples HLOOKUP function  in Excel is a sibling of the VLOOKUP function. The  H  in the HLOOKUP stands for “Horizontal” and hence it is often called Horizontal Lookup. HLOOKUP is a very useful function for creating horizontal lookups, but as most of the tables that we deal with are vertical hence this function is not very popular. The task of the HLOOKUP function is to search for a value in the topmost row of a table, and then return a corresponding value in the same column from a row you specify. Definition and Syntax of HLOOKUP Function in Excel Microsoft Excel defines HLOOKUP as a function that “looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify”. Syntax of Excel HLOOKUP The syntax of the HLOOKUP function in Excel is as follows: =HLOOKUP(lookup_value,table_array,row_index_number,range_lookup) How to Use HLOOKUP in Excel Now, let’s understand how to use this ...
Read more

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...
Read more