Hilight the Column

Go to

Format -- Conditional Formatting

Then you'll see it says Cell Value Is

Then just type in 2 and like 100000 or whatever value you want the max
number to be. Then select the format and format the cells to however you
want. And press OK.



"graeme" wrote:

what i want to do is if column I is greater than 2 turn the font in colum A
red. can anyone help me with that.

Many thanks