I'm trying to do conditional formatting for an entire column of times, to
show the time in red if it is outside of a range of time.

Column D, E and F all contain times (without dates), and I need to show the
time in column D and E red if they are greater than 75 minutes and 45 minutes
of the time in column F respectively. The formatting I've been using is as
follows:

Cell Value F4-(TIME(0,75,0)) [result is colored red if it is greater than
the time]
and
Cell Value F4-(TIME(0,45,0)) [same as above]

But I have to insert the formatting in each specific cell, which gets very
tedious for the amount of times I need to do it...
Please tell me there is a way to conditional format an entire colum to
compare (for example) cell 5 in column D to cell 5 in column F and show the
time in cell 5 red if the difference is greater than a specific time.