Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill cells based on value
I am looking for a way to fill a number of cells in a row/column based on a particular cell's value. So, if a cells value is say 7 or 3, then 7 cells or 3 cells must be be filled with a particular colour.
Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill cells based on value
I am looking for a way to fill a number of cells in a row/column based
on a particular cell's value. So, if a cells value is say 7 or 3, then 7 cells or 3 cells must be be filled with a particular colour. In my example, cells of column A are filled in based on the value in cell C1. Select column A and use "conditional Formatting" with "use a formula". The formula is =ROW()<=$C$1 Choose the format and click OK. With Excel 2010, when I update C1 the filled rows don't change (for some reason) until I select column A. Hope this helps getting started. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill a cell based on another cells value | Excel Worksheet Functions | |||
add value of cells based on the formatted fill color | Excel Worksheet Functions | |||
Is there a way to add cells based on their shading / fill colour? | Excel Discussion (Misc queries) | |||
Fill Cells Based On Cells In Another Sheet | Excel Worksheet Functions | |||
Fill cells with color based on criteria in two cells | Excel Worksheet Functions |