G
graeme
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
red. can anyone help me with that.
Many thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
AKphidelt
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.
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.
G
graeme
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.
though i would like other cells in the worksheet to appear in color also when
this situation is present is this possible.
G
Gord Dibben
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 CF>Condtion1>Formula is =$I1>2
Note the $ sign to lock in column I but allow the row number to increment.
Gord Dibben MS Excel MVP
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 CF>Condtion1>Formula is =$I1>2
Note the $ sign to lock in column I but allow the row number to increment.
Gord Dibben MS Excel MVP