Conditional Formatting

It will help you automate formatting of conditional results in such a way which is color coded and easy to see and understand.
Once defined, Excel will automatically change the color of your values e.g. up or down, high or low, pass or fail, profit or loss etc.

Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula.  For example, you can have a cell appear bold only when the value of the cell is greater than 100.

When the value of the cell meets the format condition, the format you select is applied to the cell.  If the value of the cell does not meet the format condition,  the cell’s default formatting is used. (By “default formatting”, I mean the formatting that you set up using the normal formatting tools, not necessarily the worksheet’s default font and font size.)

📌 Do subscribe to our YouTube channel & get regular updates on videos:

https://bit.ly/2THWeP3