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

How To Highlight Maximum And Minimum Value In Excel

-

 

How To Highlight Maximum And Minimum Value In Excel

 

Highlight Maximum Value

Think this that you have a list of data in range A1:F7, and you want to highlight  maximum values in Gross column. You need to use the conditional formatting for highlight maximum value. Just do the following steps_

 

1-  Select the range of cells that you want to highlight the maximum values in data,



 





2-  Go to Home tab, then click Conditional Formatting under Styles group, then click New Rule from the drop down list,



 










3-  Select Use a formula to determine which cells to format, then type the formula in the Format values where this formula is true text box, then click Format button,

=F2=MAX($F$2:$F$7)














4- Then click Fill tab, select background color as you need then click Ok button,














5-  Click ok maximum value has been highlighted.



 

 

 


Highlight Minimum Value

Think this that you have a list of data in range A1:F7, and you want to highlight  minimum values in Gross column. You need to use the conditional formatting for highlight minimum value. Just do the following steps_

 

1-  Select the range of cells that you want to highlight the minimum values in data,



 







2-  Go to Home tab, then click Conditional Formatting under Styles group, then click New Rule from the drop down list,



 










3-  Select Use a formula to determine which cells to format, then type the formula in the Format values where this formula is true text box, then click Format button,

=B2=MIN($B$2:$B$7)













4- Then click Fill tab, select background color as you need then click Ok button,






 








5-  Click ok then minimum value has been highlighted.



 















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