If one sheet is showing a name in a row how can i highlight the name on another sheet?

ady

Hi,

I have a sheet that populates names and actions next to them. I have another sheet that is names of people in different organisations. How can I Highlight a certain colour on one sheet for the name if the other sheet has the same name (if you know what i mean!!)

Paul Newcome

In the sheet you want to have the highlight on, you would insert a checkbox type column (can be hidden after setup to keep the sheet clean) and use this formula:

=CONTAINS({Source Sheet Name Column}, [Name Column]@row)

Then you would set up a conditional formatting rule to highlight the name column when the checkbox is checked.

Ashley Lewis

Hi Paul

What do I put in that formula you left? I am doing something similar to ady except the column name is VIN

My 2 sheets are Data Sheet for Cell Link and Test Cell Link SS

So would formula be:

=CONTAINS({Data Sheet for Cell Link Column}, [VIN Column]@row)

ady

I tried this again today and couldn't work it out still :-(

Paul Newcome

@Ashley Lewis The formula would go in a checkbox type column on whichever sheet you are wanting to show the highlights on.

@ady Are you getting an error?

ady

Thanks for the quick feedback, I will check tomorrow at work and let you know.

Ashley Lewis

Am I way off here?

Paul Newcome

@Ashley Lewis Your [Column name] should match exactly what is in your sheet.

[VIN Column]

should be changed to

VIN

Ashley Lewis

Am I way off here?

Ashley Lewis

Still doesnt work

Paul Newcome

@Ashley Lewis Are you getting an error?

ady

I am putting in the source SS the column from the other SS but then when i click on the column on the source i need the data to match its giving me UNPARSEABLE

I will take some screenshots tomorrow.

Ashley Lewis

I am getting the same thing ady is-UNPARSEABLE

Paul Newcome

@Ashley Lewis Are you able to provide another screenshot with the updated formula?

Ashley Lewis

Paul Newcome

@Ashley Lewis You have a closing parenthesis between VIN and @row that needs removed.