When you are done, the dialog should look something like this:
Highlight mistakes, errors, omissions, repetitions No-nonsense project plans / gantt chartsĤ. Highlighting alternative rows / columns in tablesĢ.
So you got your coffee mug? well, lets start!ġ. All you need is some coffee and this post to learn some cool conditional formatting tricks.
Better still, you dont even need to be a guru or excel pro to achieve dramatic results.
Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and good looking.