CODEWITHSUNDEEP
excellistconditional-formatting
Tiago Oliveira
Tiago Oliveira

Reputation: 43

Excel: Check Value in a list and color it according to result

I been looking for hours, for a way to check data from 1 table to another with conditional formatting, something like this :

enter image description here

And the conditional formatting would color the cell on table A if any of the items match with another from table B.

Upvotes: 0

Views: 164

Answers (1)

Vinny Roe
Vinny Roe

Reputation: 901

You can't use Conditional Formatting across worksheets (I've just realised). The only way to do it would be to have a "copy" of your lookup data on the same sheet as the cells where you want the Condintional Formatting. So set e.g. A3 = Sheet2!A3, A4 = Sheet2!A4 etc. You should then be able to use Conditional Formatting for the cells. So select one cell in table A, go to Format/Conditional Formatting and pick formula, then go for something like this:

=NOT(ISNA(VLOOKUP(D3,$A$3:$A$6,1,0)))

Where D3 is the cell in table A, and $A$3:$A$6 is the location of table B. Or similar.

Upvotes: 1

Related Questions