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)

.



.

If I put = M22<0 OR =R22<0 OR =X22<0 I get an error. If I put (= M22<0) OR
(=R22<0) OR(=X22<0) it changes it to ='(= M22<0) OR (=R22<0) OR(=X22<0)' and
there's no error but it doesn't work.

"David Biddulph" wrote:

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)

.



.


.

In that case you need to look again at the Excel help for the OR function.

It tells you that the syntax is OR(logical1,logical2,...)
and gives examples such as =OR(1+1=1,2+2=5)

It doesn't say =logical1 OR =logical2
--
David Biddulph


bwilde wrote:
If I put = M22<0 OR =R22<0 OR =X22<0 I get an error. If I put (=
M22<0) OR (=R22<0) OR(=X22<0) it changes it to ='(= M22<0) OR
(=R22<0) OR(=X22<0)' and there's no error but it doesn't work.

"David Biddulph" wrote:

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)

the excel help wasn't as helpful as you! =OR(M31<0,R31<0,X31<0) works thank
you so much.

"David Biddulph" wrote:

In that case you need to look again at the Excel help for the OR function.

It tells you that the syntax is OR(logical1,logical2,...)
and gives examples such as =OR(1+1=1,2+2=5)

It doesn't say =logical1 OR =logical2
--
David Biddulph


bwilde wrote:
If I put = M22<0 OR =R22<0 OR =X22<0 I get an error. If I put (=
M22<0) OR (=R22<0) OR(=X22<0) it changes it to ='(= M22<0) OR
(=R22<0) OR(=X22<0)' and there's no error but it doesn't work.

"David Biddulph" wrote:

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)


.

Glad to hear it.
--
David Biddulph


"bwilde" wrote in message
...
the excel help wasn't as helpful as you! =OR(M31<0,R31<0,X31<0) works
thank
you so much.

"David Biddulph" wrote:

In that case you need to look again at the Excel help for the OR
function.

It tells you that the syntax is OR(logical1,logical2,...)
and gives examples such as =OR(1+1=1,2+2=5)

It doesn't say =logical1 OR =logical2
--
David Biddulph


bwilde wrote:
If I put = M22<0 OR =R22<0 OR =X22<0 I get an error. If I put (=
M22<0) OR (=R22<0) OR(=X22<0) it changes it to ='(= M22<0) OR
(=R22<0) OR(=X22<0)' and there's no error but it doesn't work.

"David Biddulph" wrote:

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)


.