| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional color fill
The user will enter a number, let's say 10. I would then like Excel 2007 to
fill (with yellow) 10 cells starting at A1. In this example A1-A10 would be colored yellow. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional color fill
Hi
assuming B1 holds the 10: Select in column A a range that is large enough. Use Format Conditional Formatting, then "Formula is": =ROW()<=$B$1 apply your yellow colour. Hit OK. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Eric" wrote: The user will enter a number, let's say 10. I would then like Excel 2007 to fill (with yellow) 10 cells starting at A1. In this example A1-A10 would be colored yellow. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional color fill
This doesn't seem to work. When I select the range it doesn't seem to have
any effect to what happens. Can I specify the range in the formula? Again I am using 2007. "Wigi" wrote: Hi assuming B1 holds the 10: Select in column A a range that is large enough. Use Format Conditional Formatting, then "Formula is": =ROW()<=$B$1 apply your yellow colour. Hit OK. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Eric" wrote: The user will enter a number, let's say 10. I would then like Excel 2007 to fill (with yellow) 10 cells starting at A1. In this example A1-A10 would be colored yellow. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional color fill
I figured it out. You were correct if I actually used this formula in A1 but
because I started in A59 I needed to add 59 to the B1 Value "Wigi" wrote: Hi assuming B1 holds the 10: Select in column A a range that is large enough. Use Format Conditional Formatting, then "Formula is": =ROW()<=$B$1 apply your yellow colour. Hit OK. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Eric" wrote: The user will enter a number, let's say 10. I would then like Excel 2007 to fill (with yellow) 10 cells starting at A1. In this example A1-A10 would be colored yellow. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional color fill
Variations on the same theme... ;)
Glad it's solved. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Eric" wrote: I figured it out. You were correct if I actually used this formula in A1 but because I started in A59 I needed to add 59 to the B1 Value "Wigi" wrote: Hi assuming B1 holds the 10: Select in column A a range that is large enough. Use Format Conditional Formatting, then "Formula is": =ROW()<=$B$1 apply your yellow colour. Hit OK. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Eric" wrote: The user will enter a number, let's say 10. I would then like Excel 2007 to fill (with yellow) 10 cells starting at A1. In this example A1-A10 would be colored yellow. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Conditional color fill whole line... | Excel Worksheet Functions | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Linear Mode
