Colour Change on %

[paulc1232]

Can anyone help me Please

I have a spreadsheet that i need a formula that if you type less than 99% in the cell the colour changes auto to red 99%-99.9% to Amber and 100%> Green.

And also in the next cell if it red it put a 0 in it auto amber 3 and green a 5.

I hope someone can help me Please.

Thank You

 

[VoG]

Try Conditional Formatting http://www.contextures.com/xlCondFormat01.html