Good Afternoon,

I am trying to add some conditional formatting to a sheet and it is not exactly going as planned.

I have three conditions that will cause an entire row to be highlighted. I am running into an issue where one of my conditions is causing my header row to also change color. Here is what I am trying to accomplish

if T=Recevied then turn the row green
if T=On the Way then turn it red.

Those are the easy ones and work fine. The third condition is throwing the wrench in the works.

if T=On the Way and P has a number in it (the waybill) then turn it yellow.

I tried playing with the order and the "Stop if true" check box. Either my header turns yellow or my Received Items turn yellow.