Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on a vertical Array.
Would anyone have an Idea on how to apply conditional formatting to a column
(Say X2:X1000) that will only be populated with one of three words. I would like to have cell, say A12 to change colors based on X having 2 of these words. I am using two formulas for conditions 1. =if(€œWAPR€=X2:X1000,1,0) this will render a Red Cell 2. =If(€œJM€=X2:X1000,1,0) this will render Green One condition is that the Red needs to be displayed until all conditions for WARP are changed to JM. For some reason the formulas are only looking at cell X2 and nothing bellow. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on a vertical Array.
This should do it
Select A12, apply the CF using Formula Is .. Cond1: =COUNTIF($X$2:$X$1000,"WAPR") Cond2: =COUNTIF($X$2:$X$1000,"JM") Format to taste, ok out -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "cp37" wrote: Would anyone have an Idea on how to apply conditional formatting to a column (Say X2:X1000) that will only be populated with one of three words. I would like to have cell, say A12 to change colors based on X having 2 of these words. I am using two formulas for conditions 1. =if(€œWAPR€=X2:X1000,1,0) this will render a Red Cell 2. =If(€œJM€=X2:X1000,1,0) this will render Green One condition is that the Red needs to be displayed until all conditions for WARP are changed to JM. For some reason the formulas are only looking at cell X2 and nothing bellow. Please help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on a vertical Array.
Select X2:X1000
FormatCFCondition1Formula is: =$X2="WAPR" format to red Condition2Formula is: =$X2="JM" format to green Gord Dibben MS Excel MVP On Mon, 2 Feb 2009 08:04:04 -0800, cp37 wrote: Would anyone have an Idea on how to apply conditional formatting to a column (Say X2:X1000) that will only be populated with one of three words. I would like to have cell, say A12 to change colors based on X having 2 of these words. I am using two formulas for conditions 1. =if(“WAPR”=X2:X1000,1,0) this will render a Red Cell 2. =If(“JM”=X2:X1000,1,0) this will render Green One condition is that the Red needs to be displayed until all conditions for WARP are changed to JM. For some reason the formulas are only looking at cell X2 and nothing bellow. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
Conditional sum on an array based on another array | Excel Discussion (Misc queries) | |||
Conditional Formatting/Array Formula | Excel Discussion (Misc queries) | |||
Conditional formatting based upon array | Excel Worksheet Functions | |||
Conditional Formatting for Array containing Text | Excel Worksheet Functions |