A1 = data validation list with names A to Z ( range is NAMES )
How can conditionally format these names that when one is chosen the colors
will be accordinly to the letter that the name start with :
ex,. A to H names will come color blue.
I to O names will come color red.
and finally names starting with P to Z will come in color green.
THANKS for helping.