Conditional Formatting Q

J

John

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
 
B

Bob Phillips

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)
 
B

Biff

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

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
 
T

Trevor Shuttleworth

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
 
J

John

Thanks everyone

Trevor Shuttleworth said:
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
Click to expand...
 
Top