Conditional Formatting Highlight Cells Top-Bottom Rules

Highlight Require Data Using Conditional Formatting Conditional Formatting Rules Usage         In the MS Excel highlight Selected Data as per multiple conditions using Conditional formatting. First Option available for Highlight Cells rules for Numbers Greater then, Less than, Equal to and for Text option text that contains, for date Next week, Last week … Read more

Conditional Formatting Highlight Cells Rules useful MS Excel Function for Data analysis

7 Conditional Formatting Highlight Cells Rules Conditional Formatting Introduction Conditional formatting is very useful function for Highlighting cells with only given condition.Using this function analysis data very simple way in visual basis.   Change Selected cells format with value result. Multiple rules available.Learn Details. 7 Different mostly use Highlight Cells Rules 1) Greater Than 2) … Read more

SUMIF Formula & SUMIFS Formula for Summery Report in MS Excel | MS Excel Formulas | MS Excel Functions

MS Excel SUMIF Function & SUMIFS Function SUMIF Formula Sumif function use for calculate sum with condition from given data set. We can use Multiple criteria for detailed summery report.   For finding cash payment we need range, criteria & sumange. Column C is our range & cash is our Criteria. Text available in Cell F5. … Read more

COUNTIF Formula & COUNTIFS formula Make Summery Report in MS Excel |MS Excel Formulas | MS Excel Functions

Make summery Report using Countif & Countifs How to use countif formula in excel Countif Function use for Count given criteria from the large data. If once apply the formula need not update report time to time. Value will update automatic according Data Entry. In the Employee master data Staff Name, Designation & 3 department … Read more

Searchable List Using Formula IF, SEARCH, VLOOKUP, IFERROR & Search Creditors Balance in Excel

Searchable List Using Formula  Using Excel Formulas – IF, SEARCH, VLOOKUP, IFERROR We Can Search Result with Name or Code. Trace Customer Balance or Any Criteria. Find any result using any searching criteria. Ex. In the following Image looking 1st List is Creditors Balance & second List is Search list for search creditors name & … Read more