Guess you could also try this play ..
Press CTRL+A to select the entire sheet
(or just select the target rows, say rows 1 to 21)
Click Format Conditional Formatting
Under Condition 1, make the settings:
Formula is: =MOD(ROW(),3)=0
Click the Format button Patterns tab Light green? OK
Click OK at the main dialog
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"jy" wrote in message
...
Hi guys,
Thanks for the suggestions, but am wondering is it possible to do it
without any add-ins? Meaning, just by using Excel functions? ;-D
Thks again!
|