>
> So in that case, Don's VBA code should suit you fine. But if you are in
> Excel 2007 or 2010, you could use multiple conditionals for formatting
> (which is what I'd prefer, it also helps in reducing VBA)
>
> Regards,
> Sam
>
> On Tue, Nov 15, 2011 at 10:35 PM, dguillett1 wro
Case 5: x = "Five": y = 4
Case Else
End Select
Target = x
Rows(Target.Row).Interior.ColorIndex = y
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Tuesday, November 15, 2011 11:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel
Hi Sam
I am aware of the possibilities in office 2007 and later. But this
sheet will be used by multiple users, someone still in office 2003.
Therefore I will save it in the old office format.
I knew where to put Don's code, and that worked, but I then wanted to
change the words the conditional f
Don's code should be pasted in the sheet code module of the corresponding
sheet that you are working on. Please check. By the way, you wouldn't need
VBA for the desired feature if you are using Excel 2007 or greater.
Sam
On Wed, Nov 16, 2011 at 12:03 AM, FJO wrote:
> Hi Don Guillett
>
> Thanks
Hi Don Guillett
Thanks for your answer. It works perfect in the example. I then hoped
I could change a few things and the it would still work, but I can
not, and I can not see why.
Instead of writing "One", "Two" and so on in Colum A, I would like to
change this for different status, examples cou
mail.com
>
> *From:* Sam Mathai Chacko
> *Sent:* Tuesday, November 15, 2011 10:51 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Conditional formatting of entire row
> using VBA
>
> Yes Don. I was just showing how it is done for one conditional. I had
Sam, I’m sorry.I opened in xl2003duh
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Tuesday, November 15, 2011 10:51 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA
Yes
d Software
> dguille...@gmail.com
>
> *From:* Sam Mathai Chacko
> *Sent:* Tuesday, November 15, 2011 10:21 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Conditional formatting of entire row
> using VBA
>
> Here's how you do it. Select
Sam,
> "one"
> "two"
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Tuesday, November 15, 2011 10:21 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA
Here's ho
Here's how you do it. Select your entire row. Assuming your top left cell
in the entire selection is A1 (will be any one cell in the first column
depending on where you started your selection)
Go to conditional format, and in the options 'Use formula to determine
which cells to format', write =$A1
Right click sheet tab>view code>insert this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Column <> 1 Then Exit Sub
Select Case LCase(Target)
Case Is = "one": x = 1
Case Is = "one": x = 1
Case Is = "two": x = 6
Case Is = "three": x = 3
Case Is = "four": x = 4
C
11 matches
Mail list logo
