Tips+and+Tricks+for+EXCEL-+Conditional+Formatting



**We can use __CONDITIONAL FORMATTING__ in Excel to help us create a perfect spreadsheet!**

 * On this wiki, I will explain what I found on this** **SITE**

** __Highlight mistakes__ __/__ __errors / omissions__ __/__ __repetitions using conditional formatting__ __:__**


 Often we will do highly monotonous job like typing data in a sheet. Since the work is monotonous you tend to make **mistakes**, omit a few or repeat something. This can be avoided by **conditional formatting**.
 * Lets see how you can highlight a cell when it has an error:**
 * First select the cells that you want to search for errors
 * Next go to ** menu **> ** format **> ** conditional formatting and** mention the formula as**:** **=iserror** **(see below)**


 * In the same way you track repetitions, a simple ** countif ** would do the magic for you, or o missions (again a countif)
 * ** Thats it!!! **
 * **Y**ou have learned how to save tons of time by letting excel do the job for you.

Hope you enjoyed this tip!!!! Check out the link to the site I found this information on which is provided at the top of this page!!

**-<3 Chynna**