condit-format<zero-excel 2010

[John Caines]

Hello All.
I have a column of currency amounts,
The range is from,,,$O$24:$O$274

Example;
£405.00
£101.00
£87.50
-£126.00
£280.00

What I'm trying to do is conditional format a LOSS,, IE a "-£" amount to have red font colour

So, in the above example the -£126 would be font colour red as it is a loss.

Thing is, I'm trying to do this in excel 2010,, and I'm having trouble.
I think I need to go to conditional formatting & choose ;
"Use a formula to determine which cells to format"
then type in a formula;
I have now;

=$O$24:$O$274<0

but this isn't working?

Can someone advise me what I should have please.
I've tried a few,, no joy, just can't get my head around it.

Many thanks
john Caines

 

[John Caines]

Just tried it in brackets;

=($O$24:$O$274<0)

still no joy

Just tried a weird 1,, didn't like it;

=($O$24:$O$274<-£0)

Dame it.........

 

[John Caines]

Managed to get it!!!
Was using the "Use a formula to determine which cells to format",,,
Which I just couldn't get as my formulas are so good

Now tried;
"Format Only Cells That Contain"
Selected, Cell Value,,,
Selected "Less Than"
& in the formula box entered =0...

Seems to work!!!!!

Thank God.
Not sure if this is the best way,, I'm sure a formula would do it,, but hey ho...
JC