Highlight the column then click Format, Conditional Formatting. If you need
more info than this, let me know. The wizard is reasonably self-explanatory.

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"RunRonnyRun" wrote:

Hello, I am hoping someone out there can help me out, I want to change font
colour in columns but the data is in two formats, but both meaning the same
i.e. 10% & 1-10 i would like to be able to turn all data in a column to red
if say under 7% & also turn the same columns data to blue if above say 25%.
This needs to work in a few different columns and with different criteria for
some columns. Any help is appreciated.