| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a cell based on incremental numbers
I have a workbook with multiple sheets. On one sheet, I have a cell where I
manually change the contents from 1 to 12 (corresponding to months of the year). This number then is used in formulas to sum columns 1-12, depending on what the number is I have entered. Is there a way to format a cell, say fill the cell with a colour, above each column that is being summed as described above so that the columns that are not being summed have a blank cell above them? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| incremental counting based on criteria | Excel Discussion (Misc queries) | |||
| Autofilling incremental numbers in a formula | Excel Worksheet Functions | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| chart based on incremental difference | Charts and Charting in Excel | |||
| How do I create incremental numbers on an order form? | Excel Discussion (Misc queries) | |||
Threaded Mode
