Using a wild card character when looking up only negative numbers

[easybpw]

Hi,

I'm trying to do conditional formatting to fill a cell with a certain color that only finds negative numbers. The formula I'm using is below.

=VLOOKUP($C$4,'Expense'!$A$2:$A$143,3,FALSE)="*-"


This obviously is wrong but I don't know how to use the lookup only for negative numbers. So for this example if C4 contains a negative number I want to fill the cell a specific color. I know how to do that part, just don't know the formula to use.

Thanks!

Bill

 

[Fluff]

why not
=C4<0