Conditional Formatting based on a vertical Array.

  • Thread starter Thread starter cp37
  • Start date Start date
C

cp37

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.
 
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
 
Select X2:X1000

Format>CF>Condition1>Formula is: =$X2="WAPR" format to red

Condition2>Formula is: =$X2="JM" format to green


Gord Dibben MS Excel MVP
 
Back
Top