Highlight Rows
in [Programming]
|
From: Napoleon Vang on 6 Apr 2010 18:00 And also another problem I just discovered.. I am currently using Tools > CF > =MOD(ROW(),2)=1 to alternate the row colors. and it's not allowing me to highlights the alternate rows.. "Mike H" wrote: > Hi, > > Conditional formatting. Select the row(s) to which this applies then > > Format|Conditional format - Select 'Formula is' from the dropdown and enter > the formula > > =$E2="Pending" > > Click Format and on the 'Pattern' tab and choose yellow. OK > > Note that you should change the 2 to the top row of your selection > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Napoleon Vang" wrote: > > > Is there a way to program an expression close to... If cell in column E > > equals string of text "Pending", select entire row and change background > > color/patern to yellow?
From: Mike H on 6 Apr 2010 18:08 Hi, These 2 conditional formats should not conflict provided =$E1="Pending" Is the first CF condition. You then click ADD and enter your second condition. See my other post about calculation -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Napoleon Vang" wrote: > And also another problem I just discovered.. I am currently using > > Tools > CF > =MOD(ROW(),2)=1 > > to alternate the row colors. and it's not allowing me to highlights the > alternate rows.. > > > "Mike H" wrote: > > > Hi, > > > > Conditional formatting. Select the row(s) to which this applies then > > > > Format|Conditional format - Select 'Formula is' from the dropdown and enter > > the formula > > > > =$E2="Pending" > > > > Click Format and on the 'Pattern' tab and choose yellow. OK > > > > Note that you should change the 2 to the top row of your selection > > -- > > Mike > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > introduces the fewest assumptions while still sufficiently answering the > > question. > > > > > > "Napoleon Vang" wrote: > > > > > Is there a way to program an expression close to... If cell in column E > > > equals string of text "Pending", select entire row and change background > > > color/patern to yellow?
From: Napoleon Vang on 6 Apr 2010 18:42 Mike.. You are the.. MAN!!! WAHOOOO "Mike H" wrote: > Hi, > > These 2 conditional formats should not conflict provided > > =$E1="Pending" > > Is the first CF condition. You then click ADD and enter your second condition. > > See my other post about calculation > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Napoleon Vang" wrote: > > > And also another problem I just discovered.. I am currently using > > > > Tools > CF > =MOD(ROW(),2)=1 > > > > to alternate the row colors. and it's not allowing me to highlights the > > alternate rows.. > > > > > > "Mike H" wrote: > > > > > Hi, > > > > > > Conditional formatting. Select the row(s) to which this applies then > > > > > > Format|Conditional format - Select 'Formula is' from the dropdown and enter > > > the formula > > > > > > =$E2="Pending" > > > > > > Click Format and on the 'Pattern' tab and choose yellow. OK > > > > > > Note that you should change the 2 to the top row of your selection > > > -- > > > Mike > > > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > > introduces the fewest assumptions while still sufficiently answering the > > > question. > > > > > > > > > "Napoleon Vang" wrote: > > > > > > > Is there a way to program an expression close to... If cell in column E > > > > equals string of text "Pending", select entire row and change background > > > > color/patern to yellow?
From: Mike H on 6 Apr 2010 19:35
You seem to be happy, glad I could help -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Napoleon Vang" wrote: > Mike.. You are the.. MAN!!! WAHOOOO > > "Mike H" wrote: > > > Hi, > > > > These 2 conditional formats should not conflict provided > > > > =$E1="Pending" > > > > Is the first CF condition. You then click ADD and enter your second condition. > > > > See my other post about calculation > > -- > > Mike > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > introduces the fewest assumptions while still sufficiently answering the > > question. > > > > > > "Napoleon Vang" wrote: > > > > > And also another problem I just discovered.. I am currently using > > > > > > Tools > CF > =MOD(ROW(),2)=1 > > > > > > to alternate the row colors. and it's not allowing me to highlights the > > > alternate rows.. > > > > > > > > > "Mike H" wrote: > > > > > > > Hi, > > > > > > > > Conditional formatting. Select the row(s) to which this applies then > > > > > > > > Format|Conditional format - Select 'Formula is' from the dropdown and enter > > > > the formula > > > > > > > > =$E2="Pending" > > > > > > > > Click Format and on the 'Pattern' tab and choose yellow. OK > > > > > > > > Note that you should change the 2 to the top row of your selection > > > > -- > > > > Mike > > > > > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > > > introduces the fewest assumptions while still sufficiently answering the > > > > question. > > > > > > > > > > > > "Napoleon Vang" wrote: > > > > > > > > > Is there a way to program an expression close to... If cell in column E > > > > > equals string of text "Pending", select entire row and change background > > > > > color/patern to yellow? |