Is it possible to only colour cells in a range with $ amount

[pedro-egoli]

Would like to Conditional Format a range , say E54:M54 , with only those cells with a $amount in them.

Everything I have tried ends with the whole range being coloured.

Perhaps it is not possible however, thought I would ask

Pedro

 

[mikerickson]

With pre-2007 CF, once a condition is met, the format is applied and no further conditions are checked.

So if you have a negative dollar amount, it will meet condition 2, and condition 3 will not be checked.

You could use one of the standard number formats negative numbers as red.

 

[pedro-egoli]

Solved after much googling.

Custom formatted as

#,##0.00;[Red]-$#,##0.00

Thanks for anyone who looked at assisting
Just saw your post Mike after posting . Thanks again.

Pedro