I'm trying to create a formula using the time function. What I want is for
the font color to change. When I subtracting the 2 times from each other and
the difference is greater than 5 minutes, I want the font color to change to
red.

I'm trying to create a formula using the time function. What I want is for
the font color to change. When I subtracting the 2 times from each other
and
the difference is greater than 5 minutes, I want the font color to change
to
red.

Select the full range of cells (or the entire column) where your two times
are subtracted. Next, click on Format/Conditional Formatting in Excel's menu
bar. In the dialog box that comes up, leave the first drop-down field as is
(it should say Cell Value Is); in the second drop-down field, choose
"greater than" from the list. Put 00:05 in the third field (eventually,
Excel will change this to 0.00347222222222222, so you could put that in
instead). Now, click the Format button and on the Font tab, select the color
you want from the Color drop-down. Ok your way back to the spreadsheet. If
any of the cells you applied the Conditional Formatting to become greater
than 5 minutes, their font color will change to the color you selected. For
future reference, you might want to look around in the Format Cells palette
that came up when you clicked the Format button to see what other formatting
options are available to you.

Rick

Do you have 2 cells holding the times like this:

A1 = 10:00 PM
B1 = 10:15 PM

And then another cell holding a formula:

C1: =B1-A1

Need more detailed info.

--
Biff
Microsoft Excel MVP


"softballump" wrote in message
...
I'm trying to create a formula using the time function. What I want is for
the font color to change. When I subtracting the 2 times from each other
and
the difference is greater than 5 minutes, I want the font color to change
to
red.