Marking cells Good-Bad-Neutral
Sometimes when you are reviewing a file against a printed report, you may need to identify when cell values are correct, wrong or close.
Consider using the built-in Styles Good/Bad/Neutral on the Home ribbon tab – see below.
Remember they may not be useful for colour blind readers if you are sharing with other people.
Don’t forget once applied if you want to apply the same format to another cell press the F4 function key.
Once formatted you can sort or filter by colour – see right click options below.