You CAN do it with VBA, but you can also do it with Conditional formatting.The fact that you asked the question says to me that you probably don't have a lot of experience with VBA (or you'd know you can do almost ANYTHING with VBA!)
you might be more comfortable with the Conditional Formatting approach.Attached I have a sample file that highlights a single cell or three cells based on the initials in column B.
take a look and see if you can follow..
Paul-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
On Monday, September 25, 2017 7:16 PM, "Sharron Puryear sheizageek@yahoo.com [ExcelVBA]" <ExcelVBA@yahoogroups.com> wrote:
Good afternoon David.
I am hoping my issue is a simple one (for you anyhow).
I have 3 colums in a spreadsheet. . . Date, Initials and Amount.
There are 5 sales persons. Initials are JO, KB, LC, KG and Hse.
I would like my page to automatically add a color to the cell for each corresponding initials.
Is this possible in VBA?
Thanks
Sharron Puryear #yiv7989396421 #yiv7989396421 -- #yiv7989396421ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7989396421 #yiv7989396421ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7989396421 #yiv7989396421ygrp-mkp #yiv7989396421hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7989396421 #yiv7989396421ygrp-mkp #yiv7989396421ads {margin-bottom:10px;}#yiv7989396421 #yiv7989396421ygrp-mkp .yiv7989396421ad {padding:0 0;}#yiv7989396421 #yiv7989396421ygrp-mkp .yiv7989396421ad p {margin:0;}#yiv7989396421 #yiv7989396421ygrp-mkp .yiv7989396421ad a {color:#0000ff;text-decoration:none;}#yiv7989396421 #yiv7989396421ygrp-sponsor #yiv7989396421ygrp-lc {font-family:Arial;}#yiv7989396421 #yiv7989396421ygrp-sponsor #yiv7989396421ygrp-lc #yiv7989396421hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7989396421 #yiv7989396421ygrp-sponsor #yiv7989396421ygrp-lc .yiv7989396421ad {margin-bottom:10px;padding:0 0;}#yiv7989396421 #yiv7989396421actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7989396421 #yiv7989396421activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7989396421 #yiv7989396421activity span {font-weight:700;}#yiv7989396421 #yiv7989396421activity span:first-child {text-transform:uppercase;}#yiv7989396421 #yiv7989396421activity span a {color:#5085b6;text-decoration:none;}#yiv7989396421 #yiv7989396421activity span span {color:#ff7900;}#yiv7989396421 #yiv7989396421activity span .yiv7989396421underline {text-decoration:underline;}#yiv7989396421 .yiv7989396421attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7989396421 .yiv7989396421attach div a {text-decoration:none;}#yiv7989396421 .yiv7989396421attach img {border:none;padding-right:5px;}#yiv7989396421 .yiv7989396421attach label {display:block;margin-bottom:5px;}#yiv7989396421 .yiv7989396421attach label a {text-decoration:none;}#yiv7989396421 blockquote {margin:0 0 0 4px;}#yiv7989396421 .yiv7989396421bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7989396421 .yiv7989396421bold a {text-decoration:none;}#yiv7989396421 dd.yiv7989396421last p a {font-family:Verdana;font-weight:700;}#yiv7989396421 dd.yiv7989396421last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7989396421 dd.yiv7989396421last p span.yiv7989396421yshortcuts {margin-right:0;}#yiv7989396421 div.yiv7989396421attach-table div div a {text-decoration:none;}#yiv7989396421 div.yiv7989396421attach-table {width:400px;}#yiv7989396421 div.yiv7989396421file-title a, #yiv7989396421 div.yiv7989396421file-title a:active, #yiv7989396421 div.yiv7989396421file-title a:hover, #yiv7989396421 div.yiv7989396421file-title a:visited {text-decoration:none;}#yiv7989396421 div.yiv7989396421photo-title a, #yiv7989396421 div.yiv7989396421photo-title a:active, #yiv7989396421 div.yiv7989396421photo-title a:hover, #yiv7989396421 div.yiv7989396421photo-title a:visited {text-decoration:none;}#yiv7989396421 div#yiv7989396421ygrp-mlmsg #yiv7989396421ygrp-msg p a span.yiv7989396421yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7989396421 .yiv7989396421green {color:#628c2a;}#yiv7989396421 .yiv7989396421MsoNormal {margin:0 0 0 0;}#yiv7989396421 o {font-size:0;}#yiv7989396421 #yiv7989396421photos div {float:left;width:72px;}#yiv7989396421 #yiv7989396421photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7989396421 #yiv7989396421photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7989396421 #yiv7989396421reco-category {font-size:77%;}#yiv7989396421 #yiv7989396421reco-desc {font-size:77%;}#yiv7989396421 .yiv7989396421replbq {margin:4px;}#yiv7989396421 #yiv7989396421ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7989396421 #yiv7989396421ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7989396421 #yiv7989396421ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7989396421 #yiv7989396421ygrp-mlmsg select, #yiv7989396421 input, #yiv7989396421 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7989396421 #yiv7989396421ygrp-mlmsg pre, #yiv7989396421 code {font:115% monospace;}#yiv7989396421 #yiv7989396421ygrp-mlmsg * {line-height:1.22em;}#yiv7989396421 #yiv7989396421ygrp-mlmsg #yiv7989396421logo {padding-bottom:10px;}#yiv7989396421 #yiv7989396421ygrp-msg p a {font-family:Verdana;}#yiv7989396421 #yiv7989396421ygrp-msg p#yiv7989396421attach-count span {color:#1E66AE;font-weight:700;}#yiv7989396421 #yiv7989396421ygrp-reco #yiv7989396421reco-head {color:#ff7900;font-weight:700;}#yiv7989396421 #yiv7989396421ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7989396421 #yiv7989396421ygrp-sponsor #yiv7989396421ov li a {font-size:130%;text-decoration:none;}#yiv7989396421 #yiv7989396421ygrp-sponsor #yiv7989396421ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7989396421 #yiv7989396421ygrp-sponsor #yiv7989396421ov ul {margin:0;padding:0 0 0 8px;}#yiv7989396421 #yiv7989396421ygrp-text {font-family:Georgia;}#yiv7989396421 #yiv7989396421ygrp-text p {margin:0 0 1em 0;}#yiv7989396421 #yiv7989396421ygrp-text tt {font-size:120%;}#yiv7989396421 #yiv7989396421ygrp-vital ul li:last-child {border-right:none !important;}#yiv7989396421
[Non-text portions of this message have been removed]
Posted by: Paul Schreiner <schreiner_paul@att.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
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