Nice plant or not formula

[Playfieldjuly]

I am looking for a formula that can do the following:

I am interested in nature and I like to collect plants. Each plant that I have is eiter labeled "nice" or "not nice" and I also give each plant a number.
If the plant is nice it equals 1 and if the plant is not nice it equals 0

I have one excel list that looks similar to the following:
Plant identification number Nice or not nice
128 (cell A2) 1 (cell B2)
298 (cell A3) 0 (cell B3)
239 (cell A4) 1 (cell B4)
412 (cell A5) 0 (cell B5)

Further, I also have a second list which contains the plant identification number and other details of the plant.

How can I make a formula that gives the plant identification number in the second list a blue color if the plant is nice in the first list and no color if the plant is not labeled as nice in the first list?

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[Glenn Kennedy]

a bit light on detail!!

Use this as the conditional formatting formula:

=VLOOKUP(M2,A:B,2,FALSE)=1

Applied to N2:N15

[Playfieldjuly]

Thank you very much for your input.  Do you guys have some other solutions as well?

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[Glenn Kennedy]

In what way dows my suggestion NOT do what you want?

[Playfieldjuly]

Thank you for the workput input. The solution works in the workbook that is attached over, however, it does not work in the workbook that I tried to make myself. Why does it not work?

[Glenn Kennedy]

Well... for a start you did not apply the formula anywhere... and defintely not as a conditional format.

I modified the formula slightly, to suit the ranges that YOU want in your sample:

=VLOOKUP($G5,$A:$B,2,FALSE)=1