If then statement question

[lucian688]

Hi, how do I create a If Then Statement to compare ANY of the values in let's say cell B1-B200 to A1.

See typically the If then Statement to compare a single value would be = if (B1>A1, "STOP", ""), but now we need to test B2 to 1, B3 to A1, B4 to A1.... and have a message stop if ANY of the values in column B is greater than A1

Thank you!
Luke

 

[Special-K99]

If...Then is a VBA statement not a formula. but your example shows a formula.
So what ado you want a VBA solution or formula?

For formula

=IF(COUNTIF(B1:B1000,A1)>0,"STOP","")

 

[lucian688]

It's a formula we are looking for. Basically in column B we have all these dates & the goal is that if any of the dates is greater than the date in cell A1 we get a warning message.

Thanks!

 

[Special-K99]

Above should work