Hello,
I'm trying to highlight the entire row when a value in column E is exactly present in column A. I attached an example of my goal.
Thank you,
Will rep for a easily-applicable answer
Hello,
I'm trying to highlight the entire row when a value in column E is exactly present in column A. I attached an example of my goal.
Thank you,
Will rep for a easily-applicable answer
Last edited by RookA1; 02-06-2019 at 12:27 PM. Reason: Solved
This doesnt make sense.
"I'm trying to highlight the entire row"
Certain rows in the table are highlighted BUT NOT ENTIRELY, e.g. row 4 5 6 and 15. Why are they (partly) highlighted at all?
Rows 2 3 7 8 9 have the entire row highligted.
What do you consider an ENTIRE ROW to be? Col A to D or Col E to F ?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi Special-K,
The reasoning behind this is the fact that the two data sets don't match up in length. The regular IDs are a long list and the special IDs are a shorter list. My example is just an abbreviation of a much larger spreadsheet. It's true that this discrepancy makes a whole-row highlight useless.
To revise the desired outcome, the highlighting would still help even if it only applied to column A and B.
Ex. When the normal ID# in column A is present anywhere in column E, highlight the matching cell in A and the client main in B.
Delete any existing Conditional Formatting
Select columns A and B
Conditional Formatting
New Rule
Use a formula to determine...
=MATCH($A2,$E$1:$E$19,0)
Format as required
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks