Conditional Formatting in Excel is very useful to highlight cells based on cell value. In this easy tutorial, learn the basics of how to do so.
Color coding of cells based on a condition is very useful in Excel for highlighting areas and data points. It is one of the top tools in the arsenal of an Excel expert in making the spreadsheet look snazzy and convey crucial information. In this article, we show a simple example of how to apply conditional formatting to cells based on values.
Continue reading “Excel Color Coding Cells”
Learn how to use Excel SUMIF function to compute a sum of cells matching a condition.
SUMIF(range, criteria, [sum_range])
SUMIF computes sum of cells matching a condition.
Continue reading “Excel Formulas – SUMIF”