Thanks,

That fixed it. Very thankful for your help

"David Biddulph" wrote:

In which case you wouldn't expect your =D3<D2/3 formula to work, as one
variable is a number of hours and the other is an Excel time (measured in
days).

You remembered the factor of 24 in your D3 formula, but then you forgot it
in your Conditional Formatting formula.

Try =D3*24<D2/3
--
David Biddulph

"Dgwood90" wrote in message
...
This is what I have
D1 is Battery Start Run Time, formated custom m/d/yyyy h:mm
D2 is battery run time, formatted as general
D3 is Battery run time left, formated custom [h]:mm:ss, with formula
D2/24-D4
D4 is Time on Batteries, fomated custom [h]:mm:ss, with formula =NOW()-D1

"barry houdini" wrote:

Hello Dgwood90

Exactly what values do you have in D2 and D3, are they numbers like 40
and 13 or time values like 40:00 and 13:00? Are these values just
input or derived from formulas, if so which formulas?