Coloring line indicated the name, by the table where there is th [Closed]
NickBR9
Posts Tuesday December 1, 2015Registration date
November 28, 2016
Last seen
-
Nov 27, 2016 at 04:33 AM - Latest reply: Mazzaropi1834
Posts Monday August 16, 2010Registration dateContributorStatus
May 30, 2018
Last seen
- Nov 28, 2016 at 11:25 AM
Hello,
I have four tables with four different colors, are 4 different categories of staff.
First with font color blue
Second with font color red
Third with font color green
Fourth with font color black
Now in other area i choose and put randomly some names from those tables. How can these names colored according the font color of the existing tables name?
Thanks!
Were the colors of the first table colored using Conditional formatting or did you manually color it?
Can the four different categories of staff be found in a cell that individually identifies each member in its corresponding category?
If so, then you can use a rule for Conditional Formatting.
If there is no way to identify the member category except for your knowledge of each and then color manually, then the solution will be to use Excel VBA Programming.
the font of the tables I have painted manual.
yes, all the names of all 4 tables can, going through all the cells.
Already using rule formatting, but, self confused if I have two same brand-name in two different tables.
Can you help with the vba?
Hello, please look the solution here. But with this conditional formatting if I have two or more with the same lastname, in same or other table it doesn't work well. I think it only works well with VBA code, if you can give a hand that was precious to me.
yes, all the names of all 4 tables can, going through all the cells.
Already using rule formatting, but, self confused if I have two same brand-name in two different tables.
Can you help with the vba?