Conditional Formatting - Single Cells
I have a training spreadsheet for my staff, that has two columns, one for a required level and one for the completed level.
I want it so that if the completed and required columns don't match in a particular cell, the either of the completed or required cell highlight to another colour.
This will make is easier to spot where more training is required.
Help Article Resources
Check out the Formula Handbook template!