Eric,
You can also check out the free trial of my Excel add-in "Shade Data Rows".
Direct download from the products page at...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA
(Excel Add-ins / Excel Programming)
"prana1"
wrote in message
Hi,
I would like to have rows shaded only if a certain number on a row changes:
So, if the data was like the following:
50772 JONE RON 355-FT-DR
50772 JONE RON 355-FT-DR
50772 JONE RON 355-FT-DR
50772 JONE RON 355-FT-DR
19780 ASSETT JAMES 25-FT-DR
19780 ASSETT JAMES 25-FT-DR
19780 ASSETT JAMES 25-FT-DR
19780 ASSETT JAMES 25-FT-DR
19780 ASSETT JAMES 25-FT-DR
100156 BEVIS SHAWN 25-FT-DR
100156 BEVIS SHAWN 25-FT-DR
rows 1-4 and 10-11 would be shaded, skipping the rest. I have about 250
lines in total with this kind of arrangement.
I have been reading about conditional formatting, and have some ideas, but
not quite there yet! Any ideas?
Thanks,
Eric in FL