ADVANCED CONDITIONAL FORMATTING IN EXCEL

ADVANCED CONDITIONAL FORMATTING IN EXCEL

















We'll learn Advanced conditional formatting in Excel. We will use NEW RULE of conditional formatting. We'll use a formula in Conditional formatting in order to get the Rows or Columns highlighted. We will use a simple formula to highlight the cells i.e. only those cells we want to highlight. In this video, I have taken the example of GRADES of students of Class VI, Where they achieved 4 Types of grades i.e. A,B,C & D. We'll highlight all the GRADES separately with the help of a formula which we will use in New rule of Conditional Formatting. Please watch the video till the end. This will help you understand everything clearly. As a BONUS- I have also explained Nested IF function of Excel. So watch it till the end to understand everything. Check this video to get deep understanding of IF FUNCTION IF Function in Excel: https://youtu.be/EhzNZEibMtg Hope you all will like this video. If this video is helpful for you, Please Subscribe my channel to get notifications of all latest video. Don't forget to hit the bell icon. Please LIKE, SHARE & SUBSCRIBE my channel to get notifications of all latest videos. Other video you might like: # Send email from Excel (Part 2) https://youtu.be/o90j7B_jbwk # Send email from Excel (Part 1) https://youtu.be/wVx0A5spyME # How to rename sheet in Excel? https://youtu.be/FbL540jKZVU # How to use TEXT TO COLUMN in Excel? https://youtu.be/wNLvbin2oE8 # How to make Salary slip in Excel? https://youtu.be/oLdFnV2EavI # IF Function in Excel https://youtu.be/EhzNZEibMtg Tags: Conditional formatting in Excel, Conditional formatting new rule in Excel, Conditional formatting in English, Advanced Conditional formatting with a formula, Advanced Conditional formatting in Excel, Advanced Conditional formatting new rule, Advanced Conditional formatting formula in excel, If function in excel, Nested if function in excel, If function with AND function, IF function with OR Function, Excel Learning, Learn Excel in English, Conditional formatting formula, Highlight rows using Advanced Conditional formatting, Highlight columns using Advanced Conditional formatting, Advanced Conditional formatting new rule formula, Conditional formatting in Excel colour coding, Advanced Conditional formatting google sheets.



Follow this link to get Worksheet used in the video:


https://drive.google.com/file/d/10FLz_fSbJJzDDwzoC4K8l1ka5XRg_ie7/view?usp=sharing

Comments

New comments are not allowed.

Popular posts from this blog

Privacy Policy

Privacy Policy for Ms Excel tutorial- Advanced Excel- Excel for beginner At Ms Excel tutorial- Advanced Excel- Excel for beginner, accessible from https://tutorials4excel.blogspot.com/, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by Ms Excel tutorial- Advanced Excel- Excel for beginner and how we use it. If you have additional questions or require more information about our Privacy Policy, do not hesitate to contact us. This Privacy Policy applies only to our online activities and is valid for visitors to our website with regards to the information that they shared and/or collect in Ms Excel tutorial- Advanced Excel- Excel for beginner. This policy is not applicable to any information collected offline or via channels other than this website. Consent By using our website, you hereby consent to our Privacy Policy and agree to its terms. Information we collect The person
Read more

Vlookup with match function in Excel

 Vlookup with match function in Excel VLOOKUP FUNCTION IN MICROSOFT EXCEL VLOOKUP FUNCTION STANDS FOR VERTICAL LOOKUP. It looks for a value in the leftmost column of a table. It has four components: 1. VALUE - The value you want to lookup from your table. 2. RANGE- The range in which you want to find the value. 3. COLUMN NUMBER- The number of column within your defined range, that contains the return value. 4. TRUE or FALSE- False or 0 means Exact match and True or 1 means approximate match #Different ways of using Vlookup function in excel https://youtu.be/CmowjVmGRiw #Match Function in MS Excel https://youtu.be/yRy_AdWXeIg Follow this link to get worksheet used in the video- https://drive.google.com/file/d/1XotTUZ7uZt9oPqQUYA28gEOEXQ_Phcj5/view?usp=sharing MATCH FUNCTION IN EXCEL Learn Match Function in Excel with the help of examples. The MATCH function searches for a specified item in a range of c
Read more

Vlookup function in Ms Excel

Image
 Vlookup function in Ms Excel VLOOKUP FUNCTION IN MICROSOFT EXCEL VLOOKUP FUNCTION STANDS FOR VERTICAL LOOKUP. It looks for a value in the leftmost column of a table. It has four components: 1. VALUE - The value you want to lookup from your table. 2. RANGE- The range in which you want to find the value. 3. COLUMN NUMBER- The number of column within your defined range, that contains the return value. 4. TRUE or FALSE- False or 0 means Exact match and True or 1 means approximate match Follow this link to get Worksheet used in the video - https://drive.google.com/file/d/1KhigpxV9AnNVEd9dr3SVOPuDwIO6ON7O/view?usp=sharing Watch the video till the end to learn everything in detail.If you have any doubts regarding this video or any other video, do let me know in the comment section. Please LIKE 👍🏻 SHARE 🤞🏻 & SUBSCRIBE 👆🏻MY CHANNEL to get notifications of all latest videos ❤️❤️ Follow me at: Fac
Read more