Assuming the values are in A1 and B1

use formulae of

$A1=$B1

for same time

and

MAX($A1,$B1)(MIN($A1,$B1)*1.5)

for greater than 50% between

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Sushrut Sardeshmukh" wrote in message
om...
I have two columns that contain time of two runs of executables.

I want to fomrat looks of the (Format - Conditional formating) cell
using follwoing rules

some color if both runs took same time
some another color if one run took more than 50% or other run time

Time display should be in format 40:25:10 (run took 40 hrs 25 min and
10 seconds).

Can you please help me to achive this in excel ?