The conditional formatting in Excel automatically help color the cells with numbers, text or dates according to the selected criteria. You do not have to search values or use difficult filter, you can just see the colored cells. In addition, when changing values, conditional formatting immediately respond by repainting cells. You can format individual cells and also the entire row. According colors we can even filter. How to turn it on and use a simple conditional formatting, you can see in this video. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too.
Please note that this tutorial is presented in czech language.
Source file can be downloaded here.