I have an Conditional Formatting statement. Working fine.

I need the following changed:

=CONCATENATE(“OWNER:”,LOT!B8,” ASSIGNED:”,LOT!C8)

I need the word “ASSIGNED” changed to “INTERRED” IF LOT!D8 has a date inside the cell. ?  

Thanks

fordraiders

​I have an Conditional Formatting statement. Working fine. I need the following changed:=CONCATENATE(“OWNER:”,LOT!B8,” ASSIGNED:”,LOT!C8)I need the word “ASSIGNED” changed to “INTERRED” IF LOT!D8 has a date inside the cell. ?   Thanksfordraiders  Read More

​