You asked for for column A to to be CF'd based on column I but you will need a
formula in CF for that.

When you say column I 2 I assume you mean any cell in column I

Select all cells/columns to be colored then

In CFCondtion1Formula is =$I12

Note the $ sign to lock in column I but allow the row number to increment.


Gord Dibben MS Excel MVP


On Tue, 15 May 2007 20:14:01 -0700, graeme
wrote:


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