The free Excel add-in "Shade Data Rows" should do what you want.
-shades by row value or by every nth row or by row group of n size.
-shades entire row or just the selection
-shades visible rows only or hidden and visible rows
-choice of any color
-does not use conditional formatting
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"John D" <John
wrote in message
I have never used VBA so this might be very basic. I have an excel
spreadsheet and on it is a column that the user can place different initials
to indicate status of client e.g. FU; FR; SU; PE and so on. I am wanting if
its possible to have excel colour the row with a different colour for each
variation.
Can anyone suggest anything please?