Traffic light warning system
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Traffic light warning system
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Dec 2018
    Location
    Poland
    Posts
    203
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Traffic light warning system

    Hi,
    I suggesr you upload your file to dropbox in order to have a look at your data/cells setup and conditional formatting. T should work fine as long as it's set up in a proper way.

  2. #12
    Board Regular
    Join Date
    Aug 2015
    Posts
    102
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Traffic light warning system

    Quote Originally Posted by Mentor82 View Post
    Hi,
    I suggesr you upload your file to dropbox in order to have a look at your data/cells setup and conditional formatting. T should work fine as long as it's set up in a proper way.
    Think I have done this one drive share correctly....

    https://www.dropbox.com/s/6r6997wnki...Demo.xlsx?dl=0

    thanks

  3. #13
    Board Regular
    Join Date
    Dec 2018
    Location
    Poland
    Posts
    203
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Traffic light warning system

    Hi,
    Thanks for the file. I've checked that and do as follows:
    1. Get a rid of *0,1 from formulae '
    =J9/G9*0,1'
    in cel K9 because the percentage should be calculated j9/G9
    2. Go to the conditional formatting and set:
    -> First icon the red one: set value >= 0,2 instead of 20 and set type = number
    -> Second icon yellow one: set value >= 0,1 instead of 10 and set type = numer

    and now it should work
    Regards,
    Sebastian

    "When you've eliminated the impossible, whatever remains, however improbable, must be the truth."

  4. #14
    Board Regular
    Join Date
    Aug 2015
    Posts
    102
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Traffic light warning system

    Quote Originally Posted by Mentor82 View Post
    Hi,
    Thanks for the file. I've checked that and do as follows:
    1. Get a rid of *0,1 from formulae '
    =J9/G9*0,1'
    in cel K9 because the percentage should be calculated j9/G9
    2. Go to the conditional formatting and set:
    -> First icon the red one: set value >= 0,2 instead of 20 and set type = number
    -> Second icon yellow one: set value >= 0,1 instead of 10 and set type = numer

    and now it should work
    Hi
    Thank you for that, but now no icon shows??

    https://www.dropbox.com/s/6r6997wnki...Demo.xlsx?dl=0

  5. #15
    Board Regular
    Join Date
    Aug 2015
    Posts
    102
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Traffic light warning system

    Quote Originally Posted by Mentor82 View Post
    Hi,
    Thanks for the file. I've checked that and do as follows:
    1. Get a rid of *0,1 from formulae '
    =J9/G9*0,1'
    in cel K9 because the percentage should be calculated j9/G9
    2. Go to the conditional formatting and set:
    -> First icon the red one: set value >= 0,2 instead of 20 and set type = number
    -> Second icon yellow one: set value >= 0,1 instead of 10 and set type = numer

    and now it should work
    are you able to help pls?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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