On 2002-04-29 14:43, Aladin Akyurek wrote:
On 2002-04-29 14:35, giacomo wrote:
Aladin - thanks for your help, I guess I can live without the highlighted rows
Chris - my range is larger than a single printed sheet, A1:A197. But I'd like to hear your solution anyway, you've got me curious.
thanks
giacomo
Try the following, which I didn't test thoroughly:
Condition 1:
=MOD(ROW(),2)*(LEN(B:B)=0)
Format for background and font.
Condition 2:
=MOD(ROW(),2)*(MATCH(B1,CityList,0))
Format for background and font.
Condition 3:
=MATCH(B1,CityList,0)
Format just for font.
Aladin
Like this thread? Share it with others