Formual for C4:

=IF(OR(B4<"stock",B4<"np",B4<"ff",B4<""),"pc", "")

I believe the only correction you need to make to the conditional format in
B4 is to the first condition. Add the following: B4=""
You did not account for a null or empty cell.

As for the 2nd and 3rd conditon change each to the following:
#2: Formula is: =AND(B4<"",B4="ff") (blue)
#3: Formula is: =AND(B4<"",B4<"stock") (red)

I am in the habit of checking to see if the cell is blank as added protection.

Hope that works,
Les

"Alison KS" wrote:

I am unable to fathom the errors I am experiencing with the following simple
problem. Please help with the necessary formula.

I want to make the contents of cell C4 say €˜pc, but only when the contents
of cell B4 are anything EXCEPT €˜stock, €˜np, €˜ff, or blank.

That shouldnt be so difficult, but €¦

currently cell B4 has some conditional formatting which is intended to keep
the cell €˜normal if its equal to 0, or says €˜stock or €˜np, turns it blue
if it says €˜ff, but turns it red if it says anything else. This is achieved
with the following conditions in this order:

formula is =OR(B4=0,B4="stock",B4="np",C4="px in") (€˜normal format)

cell value = €œff€� (blue)

cell value not equal =€�stock€� (red)

and they work fine. However, during my attempts to formulate C4, B4 has been
turning red even though its empty. I appreciate that its the third
condition thats turning it red, but why has OR(B4=0 ceased to invoke
€˜normal formatting if theres a formula in C4? It is OR rather than AND,
after all.

What formula do I need in C4, and how do I need to amend the conditional
formatting on B4?

Might I add that thanks to the sterling efforts of those on this group, I
have always been able to find what I need to know till now. I guess Ive
worked my way into a logical loophole.