high-light certain cell

[Philangr8]

How do I high-light certain cell when the total is negative:

="if(b5)<0"
I used conditional formatting but this formular doesn't work.

Thanks,

[Special-K]

Change to

=(B5<0)

and format as required

[Philangr8]

That works for one cell but now I want the same thing from A1:A4?

Thanks.
a 1
b 3
c -10
d 2
total -4

[Special-K]

Just amend it for A1 then use format painter to copy it to A2 A3 A4