xelplus Archives - Excel-Help

Dec32020 by excelhelp13No Comments

Introduction To VBA

VBA Is A Visual Basic For Application. It's a scripting language to automate the repetitive task but its' not limited to it. Beyond that you can achieve lot's of automation with the help of VBA. You can create Application , Game , Robot Scraper and much more. VBA is a powerful and very much effective when its combine with Excel. Its very easy to understood and easy to apply in real time. So if you don't want to just limit yourself to formulas in excel and want to be a great programmer start your journey with Excel Help.

Compare Time Using If Formula

Logical, Statistical

First Select Any Of The Cell For Output Result. Apply The Formula '=IF(TIME(11,17,30)=D2,"Yes","No") Make Sure That Time After 12:00 Hr Is 13:00 As By Default The Time Value Is In 24 Hrs Format. If You Change The Format To 12 Hrs Then It Fine to Have 01;00 Hrs. But Its Vary With Time Formats. As A Result You Can Choose The Output With If Formula. That's It: :)

Conditional Formatting To Highlight Unique Values

HIGHLIGHTING CELL RULES

How to use and apply the Conditional Formatting rules by using custom options please follow the step shown below and example in image and video. NOTE:- Conditional Formatting Rules Always Work On The Base Of True & False Only. Select The Range Of Your Data. GO To Home Tab Then Go To Conditional Formatting. Then Click & Select New Rule. One Dialog Box Will Get Pop-Up Then Select Format Unique Or Duplicate In Second Last In Option List. Once Its Done Select The Formatting Option According To Your Requirement As Shown In This Example. Once It's Done Click Ok. Then Use Filter With Color And You Wil Have All Unique Numbers. That's It :)