how to colour the entire row with the selected word

M

murtuza kahn

i am working on excel my work sheet data around of 2000 colums i want
differentsiate with different colour city wise
 
C

Carole Drake

If you will click on the letters at the top, then on the color you want, the
whole column will be colored.
 
Top