| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
