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!
Related:
Coloring line indicated the name, by the table where there is th
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?