Total Posts: 19332Total Threads: 4015Posts Today: 0Lurkers: 25
no way afaik. the coloring of the background is only formatting I believe
Rezen [Truth Trollâ„¢]Apr 28, 2006 7:11:28 pm
have a spreadsheet with a few thousand rows. about half (or some large percentage of them) have a yellow background. I need to figure out a way to find out exactly how many have the yellow background.

anyone have any ideas/suggestions on how to do this?

thanks :D
syr - excels in excellenceApr 28, 2006 7:12:38 pm [NT]
Rezen [Truth Trollâ„¢]Apr 28, 2006 7:15:20 pm
hrmm probably a way to use VBA to cycle through the records and check the format settings, then increment a counter variable...
syr - excels in excellenceApr 28, 2006 7:15:55 pm [NT]
Post Reply
Name:
Subject:
Message: