conditional formatting based on the value of another cell
 

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)

conditional formatting based on the value of another cell
 

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)

conditional formatting based on the value of another cell
 

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)

conditional formatting based on the value of another cell
 

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)

.

conditional formatting based on the value of another cell
 

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)

.

conditional formatting based on the value of another cell
 

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)

.



.

conditional formatting based on the value of another cell
 

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)

.



.

conditional formatting based on the value of another cell
 

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)

.



.


.

conditional formatting based on the value of another cell
 

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)

conditional formatting based on the value of another cell
 

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)


.

conditional formatting based on the value of another cell
 

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)


.