Will this work if I have an HDMI input in the back of the computer monitor and the DVI in the back of the tower PC?
Yes, this cable will work in that configuration. This cable is bi-directional.
T​he cable is resistant to temperatures up to 100 degrees Celsius / 212 degrees Fahrenheit