Stop a formula if a cell has a certain text and show the last count where it stopped

[Alishk]

Hello experts,
So i am stuck here.

B = has a past date "01/10/21"
F = has a shipment date (if shipped)
G = has either "Shipped" "Processing" or "Canceled"
H = is counting days =TODAY()-$B2

what I want either
if F has a date
H should stop counting days further and show counted days (the difference between B date and F Date)

OR
if G is either "Shipped" or "Cancelled"
H should stop counting days further and show counted days till G value is shipped or canceled.


i also attached my sheets picture

 

[Alishk]

=if(And(f2="",B2=""),"",if(b2="","",IF(F2="",TODAY()-B2,F2-B2)))

Try!

No there is another problem. your formula works and showing black cell it is ok.
problem is now with my conditional formatting.
my conditional formating says if the value of H is >=10 highlights the whole row with red color. now when formula is applied on a black row which will be populated by a form it is highlighting it with re for no reason.

 

[Alishk]

Blank row

 

[alz]

Try This! Conditional formula
Assume you start from Row No.2

=AND($H2>=10,$H2<>"")

 

[Alishk]

Try This! Conditional formula
Assume you start from Row No.2

=AND($H2>=10,$H2<>"")

i can use this formula because it will collide with my other conditional formatting which is for example
=AND($H2>=10, $G2<>"Shipped")

 

[alz]

If you have many rules . For eg. 3 Rules .
you can set priority on conditional formating And Stop at any level you want.Tick on ( Stop if true!) in conditional formating window.

 

[Alishk]

If you have many rules . For eg. 3 Rules .
you can set priority on conditional formating And Stop at any level you want.Tick on ( Stop if true!) in conditional formating window.

Thank you for your great help. I appreciate it.
i solve my las problem by overriding a conditional formatting by create a rule on top to recolor aal rows whos value is more than 1000