Answer to Question #10634 in Other Programming & Computer Science for Adi
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
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