+ Reply to Thread
Results 1 to 3 of 3

conditional formatting using icons

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    66

    Post conditional formatting using icons

    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

    please help !!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: conditional formatting using icons

    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
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    06-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: conditional formatting using icons

    Thank U very very much for the solution. i tried but couldn't get it right. Thank you again...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1