Highlight Rows
in [Programming]
|
From: Napoleon Vang Napoleon on 6 Apr 2010 17:33 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 17:41 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: Don Guillett on 6 Apr 2010 17:44 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 dguillett(a)gmail.com "Napoleon Vang" <Napoleon Vang(a)discussions.microsoft.com> wrote in message news:630F0EEE-2924-4BCA-BA05-CA998F962995(a)microsoft.com... > 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 17:52 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?
From: Mike H on 6 Apr 2010 17:59
> 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? |