Conditional Formatting

 

 

I have Red in Cell A1

and below values in B1:B4 

Red
Blue
Yellow
Green

I have used below formula in conditional formatting new rule to highlight cell A1 with yellow if I type any of the values from B1:B4

But I am not getting any result, please help me to understand the concept

=VLOOKUP(A1,$B:$B,1,FALSE)

By: Niket

Leave a Reply

Your email address will not be published. Required fields are marked *