Re: [ExcelVBA] Formatting with Macro

 

In the files area then?

On 14/04/2012, sspatriots <sspatriots@yahoo.com> wrote:
> I can post it on Monday. It's on my work PC. Warning, it is a very long
> code...
>
> --- In ExcelVBA@yahoogroups.com, Dr John C Bullas <john.bullas@...> wrote:
>>
>> Can you post the answer please?
>>
>> Dr B
>>
>> On 14/04/2012, sspatriots <sspatriots@...> wrote:
>> > Lisa,
>> >
>> > Well I finally figured out what I was doing wrong after reading your
>> > last
>> > post. I was trying to record the macro by going through the 'Conditional
>> > Formatting - Manage Rules' menu to create the macro. It would never
>> > record
>> > those steps. Anyhow, tried what you said and after a few hours of
>> > manipulating several other rules everything works much better than I
>> > expected. I had a few problems with the part that kept trying to set one
>> > priority in front of the other...
>> >
>> > Thanks for the help and tips.
>> >
>> >
>> > Regards,
>> >
>> > Steve
>> >
>> > --- In ExcelVBA@yahoogroups.com, 1z@ wrote:
>> >>
>> >>
>> >> Hey Steve,
>> >>
>> >> I just recorded this....
>> >>
>> >> Selection.FormatConditions.AddColorScale ColorScaleType:=2
>> >>
>> >> Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
>> >> Selection.FormatConditions(1).ColorScaleCriteria(1).Type = _
>> >> xlConditionValueLowestValue
>> >> With
>> >> Selection.FormatConditions(1).ColorScaleCriteria(1).FormatColor
>> >> .Color = 2650623
>> >> .TintAndShade = 0
>> >> End With
>> >> Selection.FormatConditions(1).ColorScaleCriteria(2).Type = _
>> >> xlConditionValueHighestValue
>> >> With
>> >> Selection.FormatConditions(1).ColorScaleCriteria(2).FormatColor
>> >> .Color = 10285055
>> >> .TintAndShade = 0
>> >> End With
>> >>
>> >> I opened a new sheet, selected New Rule from Conditional formatting and
>> >> pressed enter/return so everything is default and for A1.
>> >> You can prob googlee/whatever the FormatConditions collection and so on
>> >> for more info.
>> >>
>> >> HTH
>> >> Lisa
>> >>
>> >>
>> >>
>> >>
>> >> Sent: Fri, Apr 13, 2012 2:33 pm
>> >> Subject: [ExcelVBA] Re: Formatting with Macro
>> >>
>> >>
>> >>
>> >> Hi Lisa,
>> >> Not sure I have the ability to put code together for this that
>> >> implements
>> >> onditioinal formatting of the nature I'm talking about. I still rely on
>> >> ecording macros and then editing to suit. VBA won't let me record
>> >> conditional
>> >> ormatting steps.
>> >>
>> >> hanks,
>> >> Steve
>> >>
>> >>
>> >>
>> >> [Non-text portions of this message have been removed]
>> >>
>> >
>> >
>> >
>> >
>> > ------------------------------------
>> >
>> > ----------------------------------
>> > Be sure to check out TechTrax Ezine for many, free Excel VBA articles!
>> > Go
>> > here: http://www.mousetrax.com/techtrax to enter the ezine, then search
>> > the
>> > ARCHIVES for EXCEL VBA.
>> >
>> > ----------------------------------
>> > Visit our ExcelVBA group home page for more info and support files:
>> > http://groups.yahoo.com/group/ExcelVBA
>> >
>> > ----------------------------------
>> > More free tutorials and resources available at:
>> > http://www.mousetrax.com
>> >
>> > ----------------------------------Yahoo! Groups Links
>> >
>> >
>> >
>> >
>>
>> --
>> Sent from my mobile device
>>
>>
>>
>>
>> ===========================
>> http://uk.linkedin.com/in/drjohnbullas
>>
>
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
> ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>

--
Sent from my mobile device

===========================
http://uk.linkedin.com/in/drjohnbullas

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (13)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___