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

Question #10634
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
Expert's answer
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

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be first!

Leave a comment

Ask Your question

New on Blog