Contional Formating

[bremen22]

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.

[Pecoflyer]

Perhaps posting a small example file would help? ( a sheet please, mo picture)

[bremen22]

Attached is sample set of my data

[Pecoflyer]

Does the attached help?

The word "received" has a trailing space so I had to use the isnumber(find... formula on column E for the green condition
If you get rid of that space then $e2="received" will suffice

[bremen22]

Thank you so very much