software

This is easy and I know I am overlooking something, but I was hoping one
of you could help.

If B14 equals N123AB then shade Cell I14 black.
I tried this formula in the conditional formatting box:
=if(B14=quot;N123ABquot;,) and it accepts the formula, but it wont do any
shading.

There is already a formula in I14. Does that matter or can I have a
formula in the formula box and then another conditional formula in the
condiditonal formatting box????
If it does matter,, the formula that is already in I14 is:
=IF(OR(F6=quot;N123ABquot;,F6=quot;N4APquot;,F6=quot;N213ACquot;,F6=quot;N742X quot;),H14,quot;quot;)

So essentially, if F6= N123AB (or 1 of the other stated values) then I
want I14 to be shaded while retaining the formula already in I14.

Does any of this make sense? Thanks in advance.

Mcr1--
mcr1
------------------------------------------------------------------------
mcr1's Profile: www.excelforum.com/member.php...oamp;userid=15496
View this thread: www.excelforum.com/showthread...hreadid=499473Select I14
Formatgt;Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of $B$14=quot;N123ABquot;
Format and exit

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;mcr1quot; gt; wrote in message
...
gt;
gt; This is easy and I know I am overlooking something, but I was hoping one
gt; of you could help.
gt;
gt; If B14 equals N123AB then shade Cell I14 black.
gt; I tried this formula in the conditional formatting box:
gt; =if(B14=quot;N123ABquot;,) and it accepts the formula, but it wont do any
gt; shading.
gt;
gt; There is already a formula in I14. Does that matter or can I have a
gt; formula in the formula box and then another conditional formula in the
gt; condiditonal formatting box????
gt; If it does matter,, the formula that is already in I14 is:
gt; =IF(OR(F6=quot;N123ABquot;,F6=quot;N4APquot;,F6=quot;N213ACquot;,F6=quot;N742X quot;),H14,quot;quot;)
gt;
gt; So essentially, if F6= N123AB (or 1 of the other stated values) then I
gt; want I14 to be shaded while retaining the formula already in I14.
gt;
gt; Does any of this make sense? Thanks in advance.
gt;
gt; Mcr1
gt;
gt;
gt; --
gt; mcr1
gt; ------------------------------------------------------------------------
gt; mcr1's Profile:
www.excelforum.com/member.php...oamp;userid=15496
gt; View this thread: www.excelforum.com/showthread...hreadid=499473
gt;

Hmmm. Still didn't work. Thanks for your help. O'll keep playing with
it.--
mcr1
------------------------------------------------------------------------
mcr1's Profile: www.excelforum.com/member.php...oamp;userid=15496
View this thread: www.excelforum.com/showthread...hreadid=499473