Answer to Question #10634 in Programming & Computer Science for Adi

Question

i have an excel sheet consisting of start time and stop time columns and there is a column where it shows the difference between the time
for eg: Start time 11:00:00 and Stop time 11:30:00 so the difference is 0:30:00 in hh:mm:ss format.

i need to use conditional formatting on the third column with the set of icons meeting the conditions

if the time is = 0:30:00 then exclamation mark symbol (!)
if the time is < 0:30:00 then correct mark symbol
and if the time is > 0:30:00 then (X) mark symbol

Answer 1

Change the rule to the following
(X) Mark symbol when value is greater than 0.020833334 (Note the 4 at the end)
Exclamation Mark when value is <= 0.020833334 and >= 0.020833333 (Note the 3 at the end)
Tick Mark when value is < 0.020833333 (Note the 3 at the end)
Set to Reverse icon order