| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
