Conditional Formatting multiple cells when equal to value of another cell?

Hello! I need help with conditional formatting in my sheet.

I have 8 columns that are fixed to Employee Names (for shift schedules). I want the functionality for someone to go in and select their name from a dropdown and then have their shift times (when their name is in a cell) to be highlighted.

I have another column that has a dropdown with the employees names.

I can imagine it being something like this (I'm fairly new to smartsheet and not super familiar with the formatting just yet):

If [any cell in this table] is equal to [Employee Name]6, highlight that cell.

The table is the 8 columns.

Find more posts tagged with

Accepted answers

All comments

Shu

I have a workaround for this but it's not pretty...it consists of a unique rule per person per column (so with 7 employees and 8 columns, I had to create 56 separate rules...). The rule is:

IF [Helper Employee Name] contains "(employee name X)" and Column X contains "(employee name x)" then apply this format to Column X

The X being the variable for the 7 employees across the 8 columns...

Paul Newcome

I would suggest a checkbox column (it can be hidden to keep the sheet clean) with a formula to check the box if the name "@row" matches the name in the selection.

=IF([Employee Name]@row = [Employee Name]$6, 1)

Then set up your conditional formatting based on the checkbox.

Zac Amundson

I would like to do something similar and struggling to get a formula to work. I have a column tilted [Assigned Lot #] and would like to have the box checked if another lot # added to the [Assigned Lot #] is identical to any other lot # already in that row. Is there a way to set up a formula to check the box when this occurs?

Zac Amundson

Disregard, I was able to figure this out from responses to other questions.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.