I have a template type spreadsheet and i would like to add conditional
formatting to it, but i don't know if conditional formatting can do this or
not.

I want conditional formatting to highlight rows based upon a value in a cell.

Example: in cell A1 there is a formula that generates a value of 3 ... i
want conditional formatting to then highlight 3 rows ... if the formula
generated a 15 it would then highlight 15 rows.

Any suggestions? thanks!
--
Eric