Formatting Problem

[stephen.smith]

Hi Guys
I am having a formatting problem that maybe you can help with.
I Have a spreadsheet within which i would like a number of cells formatted depending on the score which is in each cell. I have a baseline score for each client in the spreadsheet, but depending on a value they input weekly I want to see how far off the baseline they are. So I need the cell font to turn pink if they are between 85-90% of baseline, cell font to turn orange if they are between 80-85% of baseline and cell font to turn red if they are below 80% of baseline. Can anyone help please.

 

[VoG]

Have you tried Conditional Formatting http://www.contextures.com/xlCondFormat02.html

 

[stephen.smith]

Didnt know you could use formula on that. Thanks a million