excel - conditional formatting

[Saint Keith]

Hi, can someone please help me / give me, the formula or coding i need please for conditional formatting in excel

 

what i need to do is :

 

if a value is below 70% colour either the cell or the font red, if its below 80% (i.e 70-80) amber, and above 80% green

 

Thanks

 

Keith

[Johnny Shearer]

Should be able to go to Format, Conditional Formatting and then choosing the above rules.

[badgerx16]

Should be able to go to Format, Conditional Formatting and then choosing the above rules.

This

[Saint Keith]

thanks. it was help with putting in those rules that i was after

 

 

or maybe i shd just go have alook and see what i get

[badgerx16]

thanks. it was help with putting in those rules that i was after

 

 

or maybe i shd just go have alook and see what i get

As I am not on my work laptop I can't give a blow by blow guide as I use Open Office on this system, however, there is always GOOGLE;

http://www.contextures.com/xlcondformat03.html

http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel

 

etc

[Saint Keith]

i had aplay around, and although it was a bit fiddly, got it working. kind of.

 

thnx