Many thanks, that works fine. It only formats one column in the worksheet
though i would like other cells in the worksheet to appear in color also when
this situation is present is this possible.

"AKphidelt" wrote:

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