Conditional Formatting - Single Cells

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.

Find more posts tagged with

Conditional Formatting

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.