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
Posted by: "David Grugeon" <grugeon@gmail.com>
| 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