Technology Reveals Here

How to Highlight Duplicate values in Excel Watch the video for detailed Explanation: ( Click the chapter to directly view that chapter in video ) -------Contents of this Video------ 0:00 - Introduction 0:20 - Highlight Cell Rules 0:45 - Highlight cells greater than a value 1:19 - Give custom format in cell rules 1:58 - Highlight cells for values in between 2:20 - Highlight cells for a specific value 2:46 - Greater than condition for string 3:08 - Between condition for string 3:30 - Highlight cells with text that contains specific value 4:04 - Highlight cells with duplicate value 4:34 - Highlight cells with unique value 4:55 - Highlight cells with dates with specific condition 6:32 - How to delete applied conditional formatting rule in Excel 7:09 - Conclude

How to use VLOOKUP & HLOOKUP Function in MS Excel Like FB page HandPicked Songs VLOOKUP & HLOOKUP functions are mainly used to fetch a specific data from a bulk of data that we already have. So in general, We can state like we are going to look for a data we don't know with a data we already know from the sheet. VLOOKUP & HLOOKUP function are almost similar. The only difference is like VLOOKUP search for data which are fed vertically and HLOOKUP search for data which are fed horizontally. Watch the video for detailed Explanation: ( Click the chapter to directly view that chapter in video ) -------Contents of this Video------ 0:00    - Intro 0:36  - Difference between VLOOKUP & HLOOKUP