Have tried this, but C4 returns 'pc' when B4 is blank. Not sure why. But B4
has stopped going red with the formula in C4. Progress.

"WLMPilot" wrote:

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