Conditional Formatting 1

[Bill4tektips]

I am trying to set up conditional formatting for two columns of data so that if a number in coumn B appears anywhere in coumn D then the cell in column B goes Red.
What I have at the moment is:
with cell B3 selected - Cell Value Is equal to D350
but nothing happens. Any ideas anyone?

 

[GlennUK]

How about Formula Is: and a condition like:

=MATCH(B1,$D$1:$D$999,0)

and choose whatever format you want for highlighting.




Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.