Sunday, December 22

Tag: use of conditional formatting in excel

Apr152020 by excelhelp13No Comments
CONDITIONAL FORMATTING With Formula In Excel

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 Shown...
Read More
Apr112020 by excelhelp13No Comments
ICON SETS In Conditional Formatting

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.
Read More