thank you - would you also know how I can have more than one condition - I
want to say if m22<=0 OR r22<=0 OR x22<=0 format green - I'm doing something
wrong

"Gord Dibben" wrote:

Select A5 and CFFormula is: =M5<0


Gord Dibben MS Excel MVP

On Mon, 11 Jan 2010 08:12:02 -0800, bwilde
wrote:

I want to apply a conditional format to a cell based on the value of another
cell having nothing to do with the value of the cell I want the format to
effect. for example - if the value in cell m5<0 i want cell a5 to be italic
(regardless of the value in a5)

.