Highlight Rows
 

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?

Highlight Rows
 

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?

Highlight Rows
 

Sub colorif()
Dim c As Range
For Each c In Range("e1:e21")
If c = "pending" Then c.EntireRow.Interior.ColorIndex = 6
Next c
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Napoleon Vang" <Napoleon wrote in message
...
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?

Highlight Rows
 

Helps a great ton!
Though, is there a way to add, at the end of that also
"else, make the row in question the default style"?

I find that after deleting the word "Pending" it remains yellow

"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?

Highlight Rows
 

I find that after deleting the word "Pending" it remains yellow


I'm more than a little surprised it does that. Try tapping F9, does the
yellow clear?

If it does then calculation is probably set to manual

Tools|Options|Calculation tab and select Automatic
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Napoleon Vang" wrote:

Helps a great ton!
Though, is there a way to add, at the end of that also
"else, make the row in question the default style"?

I find that after deleting the word "Pending" it remains yellow

"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?

Highlight Rows
 

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?

Highlight Rows
 

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?

Highlight Rows
 

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?

Highlight Rows
 

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?