I have 2 cells which I select entries from a drop-down (A1 and A2) B2 then
does a simple subtraction of whats selected in A1 and A2

A user can select only A1 or A2, this would be incomplete thus I want in
this instance to "blank" out the value returned in B2 i.e. with white font,
as the result is not very meaning full

How would I do this under conditional formatting in B2

I thought of something like this if(or(A1=" ",A2=" "), but don't think you
can use "IF" in conditional formatting


Thanks

You don't need IF in CF, as you are only interested in a TRUE/FALSE value.
You can use it, but it is unnecessary.

Change the Condition to Formula Is and use

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John" wrote in message
...
I have 2 cells which I select entries from a drop-down (A1 and A2) B2 then
does a simple subtraction of whats selected in A1 and A2

A user can select only A1 or A2, this would be incomplete thus I want in
this instance to "blank" out the value returned in B2 i.e. with white
font,
as the result is not very meaning full

How would I do this under conditional formatting in B2

I thought of something like this if(or(A1=" ",A2=" "), but don't think you
can use "IF" in conditional formatting


Thanks

Try: =OR(ISBLANK(A1),ISBLANK(A2))

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"John" wrote in message
...
I have 2 cells which I select entries from a drop-down (A1 and A2) B2 then
does a simple subtraction of whats selected in A1 and A2

A user can select only A1 or A2, this would be incomplete thus I want in
this instance to "blank" out the value returned in B2 i.e. with white
font, as the result is not very meaning full

How would I do this under conditional formatting in B2

I thought of something like this if(or(A1=" ",A2=" "), but don't think you
can use "IF" in conditional formatting


Thanks

Hi!

I thought of something like this if(or(A1=" ",A2=" "), but don't think you
can use "IF" in conditional formatting

You can, but in this case it's not needed. Try this:

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

However, instead of using conditional formatting why not just write the
subtraction formula in B2 to test for blanks?

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

Biff

"John" wrote in message
...
I have 2 cells which I select entries from a drop-down (A1 and A2) B2 then
does a simple subtraction of whats selected in A1 and A2

A user can select only A1 or A2, this would be incomplete thus I want in
this instance to "blank" out the value returned in B2 i.e. with white
font, as the result is not very meaning full

How would I do this under conditional formatting in B2

I thought of something like this if(or(A1=" ",A2=" "), but don't think you
can use "IF" in conditional formatting


Thanks

Two ways to do this. Either modify the formula in B2 to:

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

Or use Conditional Formatting with the condition:

=OR(A1="",A2="") and just a simple A1-A2 formula

Just be careful with the quotes, as Excel sometimes doubles them up for me.
So, if you get something like ="OR(A1="""",A2="""")", you need to edit the
formula

I would suggest the formula is the simpler approach

Regards

Trevor


"John" wrote in message
...
I have 2 cells which I select entries from a drop-down (A1 and A2) B2 then
does a simple subtraction of whats selected in A1 and A2

A user can select only A1 or A2, this would be incomplete thus I want in
this instance to "blank" out the value returned in B2 i.e. with white
font, as the result is not very meaning full

How would I do this under conditional formatting in B2

I thought of something like this if(or(A1=" ",A2=" "), but don't think you
can use "IF" in conditional formatting


Thanks

Thanks everyone

"Trevor Shuttleworth" wrote in message
...
Two ways to do this. Either modify the formula in B2 to:

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

Or use Conditional Formatting with the condition:

=OR(A1="",A2="") and just a simple A1-A2 formula

Just be careful with the quotes, as Excel sometimes doubles them up for
me. So, if you get something like ="OR(A1="""",A2="""")", you need to edit
the formula

I would suggest the formula is the simpler approach

Regards

Trevor


"John" wrote in message
...
I have 2 cells which I select entries from a drop-down (A1 and A2) B2 then
does a simple subtraction of whats selected in A1 and A2

A user can select only A1 or A2, this would be incomplete thus I want in
this instance to "blank" out the value returned in B2 i.e. with white
font, as the result is not very meaning full

How would I do this under conditional formatting in B2

I thought of something like this if(or(A1=" ",A2=" "), but don't think
you can use "IF" in conditional formatting


Thanks