How to Use Conditional Formatting in Excel?
Having looked through the list a number of times you still can't find where the problem is. What is more you do this every week and it's wasting time. Conditional formating can change the colour of a cell based on the data that is in it. This online IT training video will show you how.
Use the if function file for the conditional formatting exercise.
You may have to click on enable editing in Excel to be able to complete the exercise.
Build your Excel skills further: Want to develop these skills with an instructor? View our Microsoft Excel training courses for live online, onsite and tailored Excel training.