Conditional Formatting - Single Cells

chelsea.f

Hi,

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.

Shanky Paul

Hi,

You need to add a "helper" column with a formula like below. Then you can apply the conditional formatting for the values that shows "TRUE" in helper column.

=IF([Darnar - Completed]@row = [Darnar - Required]@row, "TRUE", "FALSE")

Thank you!

chelsea.f

Hi,

Thank you for your response.

Would i need to add a helper column for each staff member?

How do i get the same rules to apply for "Clarke"?

Thank you

Debbie Sawyer

@chelsea.f

Yes, you will need a helper column per person.