Thanks for the reply. I would prefer to do it in VBA.
Sharron
From: "'David Smart' smartware.consulting@gmail.com [ExcelVBA]" <ExcelVBA@yahoogroups.com>
To: ExcelVBA@yahoogroups.com
Sent: Tuesday, September 26, 2017 2:23 AM
Subject: Re: [ExcelVBA] Colored Cells on the fly
> I didn't see that conditional formatting could do what I needed.
What you describe sounds exactly like a job for conditional formatting. Is there an added complication that makes you say this?
If not, then you just need conditional formatting with 5 rules, one for each person. Select "Format only cells that contain" and change the "between" value to "equal to". You'll be able to select all the relevant cells and set the conditional format for them all in one go.
Of course, you could also do it in VBA if you prefer, but that means that you'll always need to have macros enabled for the workbook.
Regards, Dave S
----- Original Message -----Sent: Tuesday, September 26, 2017 6:25 AMSubject: [ExcelVBA] Colored Cells on the flyI have a spreadsheet with three columns: Date, Initials and AmountThere 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=RedKB=PurpleLC=GreenKG=AquaHse=OrangeI 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
__._,_.___
Posted by: Sharron Puryear <sheizageek@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
----------------------------------
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
----------------------------------
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