Hi
if your values are in cells A1 and B1 try the following:
- select cell A1
- goto the conditional format dialog and enter the following formula
=A1=B1
- choose your format
- add a second condition and enter the following formula
=ABS(A1-B1)/B1=0.5
- choose your second format

--
Regards
Frank Kabel
Frankfurt, Germany


Sushrut Sardeshmukh wrote:
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 ?