Conditional Formatting: Identify if negative number exists.

I'm fairly knowledgeable with conditional formatting but today I've run across something that has me stumped.

I'm trying to find the formula to have a cell highlighted if any one cell in a column is a negative number.

Example
A1 will be our cell with conditional formatting, and should turn red if any cell in B1 - B5 is a negative number
B1 - B5 will be a series of numbers.

I have tried the following:
$Sheet1.$B$1:$B$5<0
($Sheet1.$B$1:$B$5)<0
IF($Sheet1.$B$1:$B$5)<0

.. am I even close?

Thanks for your time.

just highlight the cells, click conditional formatting, one of the options is "Highlight Cell Rules" then "Less Than"

If you want to use a formula all you need is the <0 and then make sure it applies to the right array.

i misread the request... thanks others.

Originally Posted by Ace_XL

In Cell A1 in conditional formatting (CF) rules

=MIN($B$1:$B$5)<0
format red

or

=COUNTIF($B$1:$B$5,"<"&0)
format red

Worked perfectly. Thanks

And thanks to the others that offered alternate tips as well.