If Function - Excel 2010 - Need him putting together a function

[RocketAnt]

I need help with a formula for one of my cells

I want to write: If D3 is greater than 90%, highlight the current cell green and write "Okay", if d3 is less than 90% but greater than 70%, highlight cell yellow and write "okay-ish", if D3 is less than 70%, highlight the cell red and write "warning".

How do I get that all in one formula, AND by highlight, I mean to fill the cell with that color.

I've attempted it but, adding the highlighting of cells is a new step for me. Thanks

 

[jscranton]

You need to use conditional formatting. Highlight Cell Rules, More Rules. Then use the Cell Value is function to select your conditions and highlighting.

 

[shyy]

You can't highlight a cell with a formula. Excel 2007 does have a built in conditional formatting with range of values. Not sure if its in older versions.

 

[RocketAnt]

Thanks!