View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
C.Poppell C.Poppell is offline
external usenet poster
 
Posts: 1
Default CF for specific ranges of time for an entire column

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.