Posts

Showing posts with the label Filter

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

ADVANCE FILTER IN EXCEL

-
Image
  Advanced filtering To filter using search: Searching  for data is a convenient alternative to checking or unchecking data from the list. You can search for data that contains an exact phrase, number, date, or simple fragment. For example, searching for the exact phrase  Saris X-10 Laptop  will display only Saris X-10 laptops. Searching for the word  Saris,  however, will display Saris X-10 laptops and any other Saris equipment, including projectors and digital cameras. 1- From the  Data  tab, click the  Filter  command. 2- Click the  drop-down arrow  in the column you want to filter. In this example, we'll filter the Equipment Detail column to view only a specific brand. 3- Enter the data you want to view in the  Search  box. We'll enter the word  Saris  to find all Saris brand equipment. The search results will appear automatically. 4- Check  the boxes next to the data you want to display. We'll disp...
Post a Comment
Read more