Saint Keith Posted 6 July, 2010 Posted 6 July, 2010 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 Posted 6 July, 2010 Posted 6 July, 2010 Should be able to go to Format, Conditional Formatting and then choosing the above rules.
badgerx16 Posted 6 July, 2010 Posted 6 July, 2010 Should be able to go to Format, Conditional Formatting and then choosing the above rules. This
Saint Keith Posted 6 July, 2010 Author Posted 6 July, 2010 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 Posted 6 July, 2010 Posted 6 July, 2010 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 Posted 7 July, 2010 Author Posted 7 July, 2010 i had aplay around, and although it was a bit fiddly, got it working. kind of. thnx
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now