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)

You need to use the CF/ Formula Is ... option, rather than CF/ Cell Value Is
....
then you can use Formula Is =M5<0
--
David Biddulph


"bwilde" wrote in message
...
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)

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)

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)

.

Perhaps you haven't looked at the Excel help for the OR function?
That will tell you the syntax of the function.
--
David Biddulph

"bwilde" wrote in message
...
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)

.

I did and I still can't seem to get it right. when i use OR either I get an
error or if I don't get and error the CF doesn't work

"David Biddulph" wrote:

Perhaps you haven't looked at the Excel help for the OR function?
That will tell you the syntax of the function.
--
David Biddulph

"bwilde" wrote in message
...
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)

.



.

Show us the formula you have used in your CF/ Formula Is condition, then we
can tell you what you've got wrong.
--
David Biddulph


bwilde wrote:
I did and I still can't seem to get it right. when i use OR either I
get an error or if I don't get and error the CF doesn't work

"David Biddulph" wrote:

Perhaps you haven't looked at the Excel help for the OR function?
That will tell you the syntax of the function.
--
David Biddulph

"bwilde" wrote in message
...
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)

.



.