Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting Highlights | Excel Discussion (Misc queries) | |||
I click on a cell and move the cursor the entire area highlights | Excel Discussion (Misc queries) | |||
I click on a cell and move the cursor the entire area highlights . | Excel Discussion (Misc queries) |