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
1
Expert's answer
2012-11-12T07:48:58-0500
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
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
Finding a professional expert in "partial differential equations" in the advanced level is difficult.
You can find this expert in "Assignmentexpert.com" with confidence.
Exceptional experts! I appreciate your help. God bless you!
Comments
Leave a comment