Traffic light warning system

[R0nseal]

Hi

Hoping someone here can help me...
I have a SS which has an income cell and then an expenses cell... In a new cell which looks at the expenses and shows what percentage of the income is now covered by expenses and gives the percentage figure and then like a traffic lights system, green from 0% to 10% then 10% to 15% amber and then at 20% i want the cell to go red...

Can anyone help?

Thanks
R0nseal

 

[Mentor82]

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.

 

[R0nseal]

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/6r6997wnkigsbbp/Demo.xlsx?dl=0

thanks

 

[Mentor82]

Hi,
Thanks for the file. I've checked that and do as follows:
1. Get a rid of *0,1 from formulae '[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

=J9/G9*0,1' ​

[/FONT]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

 

[R0nseal]

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/6r6997wnkigsbbp/Demo.xlsx?dl=0

 

[R0nseal]

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?

 

[R0nseal]

Hi,
I have not been able to get this to work still, could someone pls help?

I need it to be green and show % figure from 0 to 10, then from 10 to 15% amber then 16 to 20% red.

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

Thanks