Excel 2013: Conditional Formatting



How to Use Conditonal Formatting Using the LOOKUP and if Function

Steps

  1. Open the spreadsheet you are working on to determine what to format.For example, you may have a roster that contains a list of 200 students and their exam grades. How would you make sense of all this data? You can enter all the corresponding letter grades manually. For example, 95 percent means "A" and 90 percent means "A-," or you can use the "IF" or "LOOKUP" function in Excel and have the grades entered automatically as you type the percentage.
  2. Click on the cell you wish to write the function.
  3. The first example below uses the IF function.Type: =IF(B3>89,"A",IF(B3>79,"B", IF(B3>69,"C",IF(B3>59,"D","F")))). Notice that the letter in the roster will change live as you enter the grades. This IF function states that if B3 is > than 89 is true than assign a letter "A" grade.In the second example below, we will use the LOOKUP function. Type in =LOOKUP(B4,{40,45,60,65,80,85,90,95},{"D-","D","C-","C","B-","B","A-","A"})in B4 that corresponds to Dave. This will tell Excel to look-up the data in cell B4. This equation programs 45 percent to return a "D" grade. Do the same for B5 and B6 or you can pull down on the fill handle so that the equation applies to all the students.
  4. Practice.If you are still having trouble understanding Excel and writing equations it is because you have not yet mastered the basics. The table below will summarize the basic rules and conditional formatting guidelines. Please click on the chart below for a larger view so that you can use it as a reference.

Community Q&A

Search
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
  • There are many free self-help resources online and at your local library if you do not have the budget to take college computer courses.
  • Always review your algebra skills when typing a logical statement or an equation if math is not your best subject.
  • Always remember the order of operations when entering an equation to prevent errors.





Video: Tableau: Advanced Conditional Formatting

How to Use Conditonal Formatting Using the LOOKUP and if Function
How to Use Conditonal Formatting Using the LOOKUP and if Function images

2019 year
2019 year - How to Use Conditonal Formatting Using the LOOKUP and if Function pictures

How to Use Conditonal Formatting Using the LOOKUP and if Function forecast
How to Use Conditonal Formatting Using the LOOKUP and if Function forecasting photo

How to Use Conditonal Formatting Using the LOOKUP and if Function foto
How to Use Conditonal Formatting Using the LOOKUP and if Function images

How to Use Conditonal Formatting Using the LOOKUP and if Function How to Use Conditonal Formatting Using the LOOKUP and if Function new picture
How to Use Conditonal Formatting Using the LOOKUP and if Function new images

pics How to Use Conditonal Formatting Using the LOOKUP and if Function
picture How to Use Conditonal Formatting Using the LOOKUP and if Function

Watch How to Use Conditonal Formatting Using the LOOKUP and if Function video
Watch How to Use Conditonal Formatting Using the LOOKUP and if Function video

Discussion on this topic: How to Use Conditonal Formatting Using the , how-to-use-conditonal-formatting-using-the/
Forum on this topic: How to Use Conditonal Formatting Using the , how-to-use-conditonal-formatting-using-the/ , how-to-use-conditonal-formatting-using-the/

Related News


How Is HIV Treated
Bolten says its crucial to think of rivers as shared resources. And not just with our friends and neighbors, but with future generations, he said. Im always thinking about what my daughters reality with water is going to be
San Francisco, California
How to Pay Yourself in Your LLC
More World Cup 2019 coverage
Best Jokes About Fathers and Fatherhood
Royal Spender: Kate Middleton’s Jubilee Wardrobe Cost Around21,000
DIY Pineapple Papaya Face Mask To Exfoliate And Lighten The Skin
How to Know What to Carry in Your Purse
How to Diagnose a Seizure
This Video of Pete Davidson Watching Ariana Grande Is Either Very Adorable or Very Awkward
Carrie Underwood Loves These Leggings, And So Do I
Daclatasvir



Date: 10.12.2018, 01:42 / Views: 85153