A
Alison KS
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 shouldn’t be so difficult, but …
currently cell B4 has some conditional formatting which is intended to keep
the cell ‘normal’ if it’s 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 it’s empty. I appreciate that it’s the third
condition that’s turning it red, but why has OR(B4=0 ceased to invoke
‘normal’ formatting if there’s 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 I’ve
worked my way into a logical loophole.
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 shouldn’t be so difficult, but …
currently cell B4 has some conditional formatting which is intended to keep
the cell ‘normal’ if it’s 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 it’s empty. I appreciate that it’s the third
condition that’s turning it red, but why has OR(B4=0 ceased to invoke
‘normal’ formatting if there’s 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 I’ve
worked my way into a logical loophole.