can conditional formatting varry the area it highlights based on c
 

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

can conditional formatting varry the area it highlights based on c
 

Yes, use a formula like this over all potential rows.

=ROW()-ROW($A$10)<=$A$10


---
HTH

Bob Phillips

"Eric D" wrote in message
...
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

can conditional formatting varry the area it highlights based on c
 

CF/ Formula Is
=ROWS(A$1:A1)<=A$1

Adjust the range to suit your requirement.
--
David Biddulph

"Eric D" wrote in message
...
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

can conditional formatting varry the area it highlights based on c
 

Highlight all the cells/rows you want formatted. Format - Conditional Format,
Formula is:
=ROW()<=$A$1

Note that if you wanted an offset, say you wanted to highlight rows 5, 6,
and 7, (this is an offset of 4) the formula becomes:
=AND(ROW()+4<=$A$1,ROW()4)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eric D" wrote:

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