View Single Post
  #7   Report Post  
Max
 
Posts: n/a
Default

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!