| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| more rows highlight than I want | Excel Discussion (Misc queries) | |||
| Highlight rows | Excel Worksheet Functions | |||
| Any way to highlight rows without using macros? | Excel Discussion (Misc queries) | |||
| Highlight rows | Excel Programming | |||
| Highlight non- contiguous rows | Excel Programming | |||
![Napoleon Vang[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
