Hi!

Lets say I want to enter a specific value to A1 and have it highlighted green or blue if it equals data from either column B1:B5 or C1:C5.

For example if column B have cells with the following values; 1,3,5,7,9 and column C have 2,4,6,8,10. I want to use cell value equal to, but then I can only use 1 specific cell, not multiple cells.

I've been playing around with different formulas such as =MATCH but I can't get it to work.

Can anyone help me out? :-)