I have an IF statement based on 2 criteria in an OR statement.

.....IF a1=a2 or a1=a3, show a1 contents in a4....for instance.

I want to format a2 automatically depending on which of the 2 statements
about a1 turn out to be TRUE.

If a1=a2, show contents in a4 and make it bold text...if a1=a3, show
contents in a4, and make it italic text....for instance.

The problem is I can't use conditional formatting for the specific cells,
because the value in a4 is going to change depending on what I type in a2 and
a3.

Can anyone help?

In conditional formatting select: Formula is: and enter the formula =A1=A2
and format for Bold then in Condition 2 the formula =A1=A3 and format for
Italic

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"veggies27" wrote in message
...
I have an IF statement based on 2 criteria in an OR statement.

....IF a1=a2 or a1=a3, show a1 contents in a4....for instance.

I want to format a2 automatically depending on which of the 2 statements
about a1 turn out to be TRUE.

If a1=a2, show contents in a4 and make it bold text...if a1=a3, show
contents in a4, and make it italic text....for instance.

The problem is I can't use conditional formatting for the specific cells,
because the value in a4 is going to change depending on what I type in a2
and
a3.

Can anyone help?

In A4 enter:

=IF(OR(A1=A2,A1=A3),A1,"")

Then select A4 and enter two conditional formats:

1. Formula Is =A1=A2 and pick Bold
2. Formula Is =A1=A3 and pick Italic
--
Gary''s Student - gsnu200774


"veggies27" wrote:

I have an IF statement based on 2 criteria in an OR statement.

....IF a1=a2 or a1=a3, show a1 contents in a4....for instance.

I want to format a2 automatically depending on which of the 2 statements
about a1 turn out to be TRUE.

If a1=a2, show contents in a4 and make it bold text...if a1=a3, show
contents in a4, and make it italic text....for instance.

The problem is I can't use conditional formatting for the specific cells,
because the value in a4 is going to change depending on what I type in a2 and
a3.

Can anyone help?

What about if I am drawing from another worksheet? A2 and A3 in the cases
below are in another worksheet. Conditional fomrating wont let me use a
formula containing abnother worksheet.

"Gary''s Student" wrote:

In A4 enter:

=IF(OR(A1=A2,A1=A3),A1,"")

Then select A4 and enter two conditional formats:

1. Formula Is =A1=A2 and pick Bold
2. Formula Is =A1=A3 and pick Italic
--
Gary''s Student - gsnu200774


"veggies27" wrote:

I have an IF statement based on 2 criteria in an OR statement.

....IF a1=a2 or a1=a3, show a1 contents in a4....for instance.

I want to format a2 automatically depending on which of the 2 statements
about a1 turn out to be TRUE.

If a1=a2, show contents in a4 and make it bold text...if a1=a3, show
contents in a4, and make it italic text....for instance.

The problem is I can't use conditional formatting for the specific cells,
because the value in a4 is going to change depending on what I type in a2 and
a3.

Can anyone help?

Cheat and use a local cell. For example, if we want to test if A1 is equal
to A1 on Sheet2, then do not use:
=A1=Sheet2!A1
use:
=A1=B1
and set B1 up as =Sheet2!a1


REMEMBER. cells are cheap, your time is valuable...use the extra cell!
--
Gary''s Student - gsnu200774


"veggies27" wrote:

What about if I am drawing from another worksheet? A2 and A3 in the cases
below are in another worksheet. Conditional fomrating wont let me use a
formula containing abnother worksheet.

"Gary''s Student" wrote:

In A4 enter:

=IF(OR(A1=A2,A1=A3),A1,"")

Then select A4 and enter two conditional formats:

1. Formula Is =A1=A2 and pick Bold
2. Formula Is =A1=A3 and pick Italic
--
Gary''s Student - gsnu200774


"veggies27" wrote:

I have an IF statement based on 2 criteria in an OR statement.

....IF a1=a2 or a1=a3, show a1 contents in a4....for instance.

I want to format a2 automatically depending on which of the 2 statements
about a1 turn out to be TRUE.

If a1=a2, show contents in a4 and make it bold text...if a1=a3, show
contents in a4, and make it italic text....for instance.

The problem is I can't use conditional formatting for the specific cells,
because the value in a4 is going to change depending on what I type in a2 and
a3.

Can anyone help?

You can use a range or cell from another worksheet if you name that range or
cell.


Gord Dibben MS Excel MVP

On Wed, 19 Mar 2008 08:04:05 -0700, veggies27
wrote:

What about if I am drawing from another worksheet? A2 and A3 in the cases
below are in another worksheet. Conditional fomrating wont let me use a
formula containing abnother worksheet.

"Gary''s Student" wrote:

In A4 enter:

=IF(OR(A1=A2,A1=A3),A1,"")

Then select A4 and enter two conditional formats:

1. Formula Is =A1=A2 and pick Bold
2. Formula Is =A1=A3 and pick Italic
--
Gary''s Student - gsnu200774


"veggies27" wrote:

I have an IF statement based on 2 criteria in an OR statement.

....IF a1=a2 or a1=a3, show a1 contents in a4....for instance.

I want to format a2 automatically depending on which of the 2 statements
about a1 turn out to be TRUE.

If a1=a2, show contents in a4 and make it bold text...if a1=a3, show
contents in a4, and make it italic text....for instance.

The problem is I can't use conditional formatting for the specific cells,
because the value in a4 is going to change depending on what I type in a2 and
a3.

Can anyone help?