Check the response below...
the important thing is the right selection of the range, and the relative
references.
[image: Inline image 1]
Saludos from México
On Mon, Sep 25, 2017 at 9:07 PM, 'David Grugeon' grugeon@gmail.com
[ExcelVBA] <ExcelVBA@yahoogroups.com> wrote:
>
>
> Looks easy enough. Use conditional formatting, select col B select
> Conditional formatting, select "use a formula" put in the formula =B1="JO"
> and set the format to red, then add another condition for =B1="KB" and set
> the format to Purple etc…
>
>
>
> Regards
>
> David Grugeon
>
> 0429 029 836
>
>
>
> *From:* ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]
> *Sent:* Tuesday, 26 September 2017 6:25 AM
> *To:* ExcelVBA@yahoogroups.com
> *Subject:* [ExcelVBA] Colored Cells on the fly
>
>
>
>
>
>
>
>
> I have a spreadsheet with three columns: Date, Initials and Amount
>
>
>
> There are 5 sales person's initials: JO, KB, LC, KG and Hse.
>
>
>
> I would like for the cells with the initials in it to change to their
> respective cell colors when a sale is made and the initials are typed in a
> cell.
>
>
>
> JO=Red
>
> KB=Purple
>
> LC=Green
>
> KG=Aqua
>
> Hse=Orange
>
>
>
> I need them to change on the fly if possible. I didn't see that
> conditional formatting could do what I needed.
>
>
>
> Any help is appreciated.
>
>
>
> Thanks,
>
>
>
> S. Puryear
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Posted by: Alejandro Tapia Mendiola <alxtapia@gmail.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
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
----------------------------------
Tidak ada komentar:
Posting Komentar