Good Day,

I am having problem on highlighting rows based on my input in Exce
using VBA.

I do not know how to do this :

If my input(in sheet 1 ) is 8, then, i want VBA in excel to generate
rows highlighted in yellow automatically(in sheet 2).
There must be 2 blank rows which is separating each yellow line tha
has been generated.

Pls refer to my attachement if you don't understand my explanations
The one i did in the attachement is manually done.

Thank you

regards
Reen

Attachment filename: problem.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=55066
--
Message posted from http://www.ExcelForum.com

Use Conditional Formatting (FormatConditional Formatting

Select rows 1-24
Go to CF
Change Condition 1 to Is Formula
Add a formula of =MOD(ROW(),3)=1
Click the Format button
Select the pattern tab
Choose the yellow
Exit CF

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"schreena " wrote in message
...
Good Day,

I am having problem on highlighting rows based on my input in Excel
using VBA.

I do not know how to do this :

If my input(in sheet 1 ) is 8, then, i want VBA in excel to generate 8
rows highlighted in yellow automatically(in sheet 2).
There must be 2 blank rows which is separating each yellow line that
has been generated.

Pls refer to my attachement if you don't understand my explanations.
The one i did in the attachement is manually done.

Thank you

regards
Reena

Attachment filename: problem.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=550668
---
Message posted from http://www.ExcelForum.com/