excelhelp13, Author at Excel-Help

Apr152020 by excelhelp13No Comments

CONDITIONAL FORMATTING With Formula In Excel

NEW RULE

How to use and apply the Conditional Formatting rules by using custom formulas please follow the step shown below and example in image and video. NOTE:- Conditional Formatting Rules Always Work On The Basis Of True & False Only.Whether The Condition Should Be True Or Condition Should Be False.First Create A Formula On The Base Of Your Requirement In Excel Sheet.Once Created Check The Result It Should Be Either True Or False.Now Select The Range Of Your Data.GO To Home TabThen Go To Conditional Formatting.Then Click & Select New Rule.One Dialog Box Will Pop-UpThen Select Use A Formula - Last In Option List.Type The Formula In Rule Description Or Paste The Formula You Already Created In Excel Sheet.Once Its Done Select The Formatting Option According To Your Requirement As Show...

Apr132020 by excelhelp13No Comments

FIND SMALLEST Number With Position In Excel

Statistical

First Select The Cell Where You Want The Result.Then Apply The Formula And Select The Array / Range And Define The Position. Once Applied It Will Check In The Array And Give You The Result By Finding The Position Of The Smallest Number.That's It :)

Apr132020 by excelhelp13No Comments

DEPENDENT Drop Down List In Excel

Lookup & Reference

TO create a dependent drop down list please follow the step shown below and example provided with image and video under it. First Select The Reference Cell Where you Want To Have Drop Down List.Then GO To Data Tab.Then Go To Data Validation.One Dialog Box Will Pop-Up.Under That Select The List From Drop Down List.Then Under That In Source Tab Just Provide The Reference Range And Click Ok.Once Your Drop Down List Created Move To Next Column Cell.Then Again Go To Data Validation And Paste This Formula =OFFSET($D$1,1,MATCH($A2,$D$1:$F$1,0)-1,10,1) And Click Ok.OFFSET FUNCTION:- Offset Function Return A Reference To A Range For The Given Number Of Rows And Columns For The Given Reference.MATCH FUNCTION:- Match Function heck The Position Of A Particular Reference In A Given Array.NOTE:- If ...

Apr112020 by excelhelp13No Comments

ICON SETS In Conditional Formatting

CONDITIONAL FORMATING, ICON SETS

How to use and apply the ICON SETS rules in conditional formatting please follow the step shown below and example in image and video. GO To Home Tab.Then Go To Conditional Formatting.Under That Go To ICON SETS.In That You Will Find Several ICON SETS With Different Colors.You Can Choose According To Your Choice Which Make Your Database Looks Good.This Rules Work To Highlight The Data With Color Scale To Find The Lowest To Highest Value Within The Table Range By Different Icon Sets.It Usually Used By Sales Company To Generate The Reports.

Apr112020 by excelhelp13No Comments

COLOR SCALE In Conditional Formatting

COLOR SCALE

How to use and apply the COLOR SCALE rules in conditional formatting please follow the step shown below and example in image and video. GO To Home Tab.Then Go To Conditional Formatting.Under That Go To Color Scale.In That You Will Find Several Color Scale With Different Colors.You can choose according to your choice which make your database looks good.This Rules Work To Highlight The Data Sets To Find The Lowest To Highest Data Sets Within The Table Range By Different Color Scale.It Usually Used By Sales Company To Generate The Reports.

Apr112020 by excelhelp13No Comments

DATA BARS In Conditional Formatting

DATA BARS

How to use and apply the DATA SETS rules in conditional formatting please follow the step shown below and example in image and video. GO To Home Tab.Then Go To Conditional FormattingUnder That Go To Data SetsIn That You Will Find Several Data Sets With Different Colors.You can choose according to your choice which make your database looks good.This Rules Work To Highlight The Data Sets To Find The Lowest To Highest Data Sets Within The Table Range By Different Color Sets.It Usually Used By Sales Company To Generate The Reports.

Apr112020 by excelhelp13No Comments

TOP BOTTOM RULES In Excel Conditional Formatting

TOP / BOTTOM RULES

How to use and apply the Top / Bottom rules in conditional formatting please follow the step shown below and example in image and video. TOP 10 ITEMS:- When you apply this highlighting rule it will highlight the top 10 highest number from the table range. TOP 10%:- When you apply this highlighting rule it will highlight the top 10% of the table count cell. Suppose there are 24 cell are there in a selected table and 10% of 24 is 2.4% then it will highlight 2 top value of the entire table range. BOTTOM 10 ITEMS:- When you apply this highlighting rule it will highlight the bottom 10 lowest number from the table range. BOTTOM 10%:- When you apply this highlighting rule it will highlight the bottom 10% of the table count cell. Suppose there are 24 cell range selected an...

Apr112020 by excelhelp13No Comments

CONDITIONAL FORMATING In Excel

NEW RULE

To Use And Apply The Conditional Formatting Please Follow The Step Shown Below And Example In Image And Video. HIGHLIGHT GREATER THAN:- When you apply this greater than highlighting rule it will highlight the number which is greater than the reference number.LESS THAN:- When you apply this less than highlighting rule it will highlight the number which is less than the reference number.BETWEEN:- When you apply this between highlighting rule it will highlight the number which is are between the given two reference number.EQUAL TO:- When you apply this equal to highlighting rule it will highlight the number which is equal to or same to reference number.TEXT THAT CONTAINS:- When you apply this text to contains highlighting rule it will highlight the text from the selecti...

Apr72020 by excelhelp13No Comments

PRINT TITLE On Every Page In Excel

FORMULAS, Page Layout, Statistical

How to use the already built in function in excel for printing the title on every page. Please follow the step mentioned below. GO to Page Layout.Then go to Print Tiles and click on it.Then you will see One Dialog Box Will Appear.In that dialog box go to the Repeat On Top Option.After that select the option showing Title range.Then simply click ok button located at bottom right in dialog box.That's it :)

Apr72020 by excelhelp13No Comments

SUM AVERAGE MAX & MIN Function In Excel.

FORMULAS, Maths

For using these 4 function in excel and to know the actual purpose of all those function. Please follow the step mentioned below. SUM () function add all the numeric value available in different range. SUM() function only need the reference range For Example:- =SUM(B2:C7)AVERAGE () function add all the numeric value available in different range and divide it by the counting the cell with numeric value available. Suppose there are 4 cell and its total is 100 then Average () function will divide 100 by 4 100/4 = 25 is the average. For Example:- =AVERAGE(B2:C7)MAX() function find the bigger number from the given range or a cell reference. Suppose there are 4 cell and its contain 10, 20, 30, 40, then MAX() function will give you the 40 as a max number. For Example:- =MAX(B2:C7)MIN() functi...