Conditional formatting with colour

Hi,

Im trying to create a stock database based on a colour traffic light system. I have 2 set columns, the first is 'recommended stock' the second is 'actual stock'
When you paste in your requirements into the 3rd column it subtracts it from the acutal stock which tells you how much your recommended stock is short by.
What ive got as well is any stock above 1+ shows up in green (this needs changing - see below), anything below 0 shows up in red. What im struggling with is i want a rule that reads the recommended stock level, then flags it up yellow when the actual stock levels drop to 10% of full stock.

Can anyone advise on how to use the conditional formatting if that is the way.

Thanks

Lee

Martin,

Thanks for that, I put the formula in using the relevant cells and it does change the colour correctly when the figure goes less than 10%. One thing i might not have made clear was that this is a list of items, not just one. When i tested your formula not only did the current item go yellow, the whole list went yellow, this must be because i selected the whole lot of items rather than just one line. Do i have to apply this rule to each line individually (Theres 200+ items!)

Thanks

Lee

Hi,

I set off with the best will to amend the formula, despite nearly half a day playing with it i dont feel much closer! I have attached my file in its original form, if you could spare a little time and correct my errors id much appreciate it! Note that i cant change the layout of the sheet because i need to paste data to the right hand side.

Thanks
Lee

Martin I could kiss you, (but ill not, wouldnt want to scar you for life!)

One last thing, when the figures go below 0 ie into minus numbers, is there a an alteration I can make so the minus figures appear in red instead of yellow?

Thanks
Lee

Hi Martin,

You gave me great help with this. Ive been trialling it over the last couple of weeks and theres a couple of small changes to make which i (sadly!) cant do without some help.

On the attachment, Im trying to get the 'reduced stock' column to be green if the 'reduced stock' figure is above the 'minimum stock' value.
If the 'reduced stock' hits the 'minimum stock' value or below then it would be yellow.
If the 'reduced stock' hits zero or minus figures then it would be red.

I think ive managed to confuse myself into an early grave!

Thanks all!
Lee