Conditional formatting - multiple values

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? :-)

HI,

Apply Green format with

Formula:

Please Login or Register  to view this content.

and Apply Blue format with

Formula:

Please Login or Register  to view this content.

Bas

The second formula needs to be

Formula:

Please Login or Register  to view this content.

Cheers!

Thanks a lot!