Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF Row after CF applied to Column
I've been reading the posts but still don't get it. I have data down columns
A:O for 2000+ rows. In Column J, I selected the entire column and applied CF to it so that if any text is entered into a cell, that cell will turn yellow. I'm lost as to how to get the entire row A:O of each cell in J which contains text to turn yellow. I'm running 07. Can anyone help me in English as to what the steps are or point me to the appropriate post? Thanks in advance! -Dax -- I would give my left hand to be ambidextrous! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF Row after CF applied to Column
--Select the range of cells. Assume this range is A1:O2000. Please note that
the row number mentioned in the formula is the row containing the active cell in the selection. Active cell will have a white background even after selection --Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format --Enter this formula in the box below: =ISTEXT($J1) --Click the Format button. Select the desired style(s). Hit OK If this post helps click Yes --------------- Jacob Skaria "Dax Arroway" wrote: I've been reading the posts but still don't get it. I have data down columns A:O for 2000+ rows. In Column J, I selected the entire column and applied CF to it so that if any text is entered into a cell, that cell will turn yellow. I'm lost as to how to get the entire row A:O of each cell in J which contains text to turn yellow. I'm running 07. Can anyone help me in English as to what the steps are or point me to the appropriate post? Thanks in advance! -Dax -- I would give my left hand to be ambidextrous! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF Row after CF applied to Column
Thanks for your help and sorry about the multi-posting, I waited 5 minutes
and didn't see my posting and thought I had done something wrong. -- I would give my left hand to be ambidextrous! "Jacob Skaria" wrote: --Select the range of cells. Assume this range is A1:O2000. Please note that the row number mentioned in the formula is the row containing the active cell in the selection. Active cell will have a white background even after selection --Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format --Enter this formula in the box below: =ISTEXT($J1) --Click the Format button. Select the desired style(s). Hit OK If this post helps click Yes --------------- Jacob Skaria "Dax Arroway" wrote: I've been reading the posts but still don't get it. I have data down columns A:O for 2000+ rows. In Column J, I selected the entire column and applied CF to it so that if any text is entered into a cell, that cell will turn yellow. I'm lost as to how to get the entire row A:O of each cell in J which contains text to turn yellow. I'm running 07. Can anyone help me in English as to what the steps are or point me to the appropriate post? Thanks in advance! -Dax -- I would give my left hand to be ambidextrous! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF Row after CF applied to Column
Thanks for the help. It actually gets worse. In column C I'm entering M or
F (for male or female) and I need to color the entire row either blue or pink (yeah, I know, I know, sorry to stereotype but it's not my worksheet) depending upon their sex. How do I specify the text in that specific column? I tried =ISTEXT($C1,"M") but it says those are too many arguements. Not sure where to go from there. Any help? -- I would give my left hand to be ambidextrous! "Jacob Skaria" wrote: --Select the range of cells. Assume this range is A1:O2000. Please note that the row number mentioned in the formula is the row containing the active cell in the selection. Active cell will have a white background even after selection --Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format --Enter this formula in the box below: =ISTEXT($J1) --Click the Format button. Select the desired style(s). Hit OK If this post helps click Yes --------------- Jacob Skaria "Dax Arroway" wrote: I've been reading the posts but still don't get it. I have data down columns A:O for 2000+ rows. In Column J, I selected the entire column and applied CF to it so that if any text is entered into a cell, that cell will turn yellow. I'm lost as to how to get the entire row A:O of each cell in J which contains text to turn yellow. I'm running 07. Can anyone help me in English as to what the steps are or point me to the appropriate post? Thanks in advance! -Dax -- I would give my left hand to be ambidextrous! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF Row after CF applied to Column
Select range A1:O2000
Condition1 CF formula would be =$C1="M" Condition2 CF formula would be =$C1="F" Gord Dibben MS Excel MVP On Mon, 30 Nov 2009 16:58:01 -0800, Dax Arroway wrote: Thanks for the help. It actually gets worse. In column C I'm entering M or F (for male or female) and I need to color the entire row either blue or pink (yeah, I know, I know, sorry to stereotype but it's not my worksheet) depending upon their sex. How do I specify the text in that specific column? I tried =ISTEXT($C1,"M") but it says those are too many arguements. Not sure where to go from there. Any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No more new fonts may be applied in this workbook | Excel Discussion (Misc queries) | |||
Re-running an AutoFilter filter when applied to a hidden column .. | Excel Worksheet Functions | |||
Need help on my Jobs applied too SS | Excel Discussion (Misc queries) | |||
no more new fonts may be applied in this workbook... | Excel Worksheet Functions | |||
some view settings could not be applied | Excel Discussion (Misc queries) |