I have a row of data: A1=ticketnumber B1=priority(low,med,high) C1=description D1=persons name E1=orginizations F1=last modified G1= date reported H1=Todays date J1=days open K1= days since last update
i basilcy want B1 to change names from low,med,high based on the values in J1. So if J1 is...