I want to be able to highlight a specific cell, and all other cells on the sheet with the same text also get highlighted
Our take
Hello all, I've been searching for a solution, but I haven't been able to find it. I keep seeing similar things, but not exactly what I'm looking for.
Basically I have a few columns that have names in them. Sometimes they are repeated in other columns, sometimes not. What I want to be able to do is click any cell in Column A and highlight it eg- John Doe, and then any John Doe's in the other columns also become highlighted. And I want the highlight to stick, I don't want to just click a cell in column A and it temporarily highlights the same text elsewhere. I want to highlight the cell and all other cells with the same text get highlighted and stay highlighted. That way I can continue highlighting cells in Column A, and all the matches in other columns stay highlighted.
Does this make sense and is it possible? Thanks!
EDIT: Specifically, I have a main list of sports player names in column A. And those names could be found in other columns if they're an offensive or defensive player. I've been highlighting each name in column A and then manually finding the names in other columns and highlighting them. I want to be able to highlight the name in Column A and if it's in any other columns it will also get highlighted.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Highlight non-adjacent cells that have same content in three columnsHave worksheet with several columns and multiple rows where need to highlight cells that have same data as in other rows. Basically, if column A, B and G have identical information in rows 7 and 183, these cells will all highlight. Goal is to identify if the same sequence of data is present, in another row of the worksheet. I have used following formula previously: =Countifs($A$7:$A$319,$A7,$B$7:$B$319,$B7)=1 However, I now need to innclude data that also appears same in column G. Note: the data in each column is different, Example: Row: 7: Column A: ABCD, Column B: 1234, Column G: Foxy Row: 183: Column A: ABCD, Column B: 1234, Column G: Foxy This match would highlight, but if one data point differs, no match. Hope someone can help here... Thank you. submitted by /u/ThunderWarrior3 [link] [comments]
- How to highlight if values in three columns match?So I work for an insurance company and yesterday they found out that the system is somehow duplicating claims so they have about 10 people going through a spreadsheet to find spots where three columns match/have the same value. I've highlighted the person's ID number in red so we know to ignore the grey values since they're not duplicates so now I'm trying to figure out the best way to identify if the other values match each other. So I need like an "if column A is equal to column B and column C highlight them or something of that nature." I'm not sure if Excel can do this. Thanks in advance. If that's not clear I mean if values in all three fields are the same we're going through and marking them but this will take like 80 man hours or more and mistakes will be made. submitted by /u/memento22mori [link] [comments]
- Highlighting certain text contained within a text issueHi guys! Confusing title. Hopefully I can explain this better. I am trying to highlight a column that contains the text “RAF”, however I have a “CRAF” also in that column. The column also contains many lines that say CRAF RAF. I only want it to highlight the columns with CRAF if RAF is present as a separate word. I’ve tried to do a text to column since CRAF should be the first word on any row. But some of the rows in this column are 20-30 words and RAF could be in any of the other words. I’ve focused on an example of a cell. I am just struggling with the formula to use. Please help! Example in comments. submitted by /u/kittychlo [link] [comments]
- Highlighting duplicates from two different worksheets, but only when all of the data in a row matchesHey guys. Sorry to post such a random question. Essentially, I've got two sheets I'm working off. The jist is on sheet 1 I've got new fresh data, on sheet 2 I've data from a few years back. Essentially, I want to paste in the old data into sheet 2 and have it highlight on sheet 1 if the data matches everything columns A through E on each so that it isn't used again. I've tried everything I can think of, and I'm probably missing something really obvious. I get Too Many Arguments error, or it only matches data on a single column. Can anyone point me in the right direction as I'm pulling my hair out over this. Much appreciated submitted by /u/Neon_Banana_Pickle [link] [comments]