Changing a textbox style depending on the value of a cell

How do I Change the value and style of a text box depending on the value of a cell in the workbook. This box is only for display and does not return any values past this form.

Thanks

Here is the file.

The value of the cell is not a fixed cell but the last entry of that number from a list and a second entry in column 21 from the same row.

In this application ALL references to rows or columns are populated on command and can move around on the sheet.

The box I want to apply the changes too is TextBox7 on the only user form.
It must find the number and if there is no return date the it must say Out,date and to whom.
else if there is a return date it must say the last time it was out and to whom.

For some reason the file is too big to upload 2.9 mb and I can not get it smaller.

Thanks Joseph

I think I sorted it

I used an for loop to find the first instance of that number but I did not exit the loop soon enough.

Thanks for trying