Hello all,
First post here, hopefully it's in the right spot. I have been scouring the forum looking for a solution to this problem, but to no avail so far.
Basically, I have a workbook that visually reports the Fiscal Year status of our product in the field. The Fiscal Years run from FY 11 to FY 30. The product version is set to automatically change based on the value in a separate spreadsheet, and conditionally change color based on said value. This works fine, and is accomplished by a simple IF statement/formula shown below:
=IF('Fielding Plan '!$D11="Upgrade","CXG 1","")
The problem, however, comes next. Taking a portion of the workbook as an example, the status of our product may look like this:
<tbody>
</tbody>
This is done to multiple versions of our product, not just CXG. So what I am trying to accomplish, is to pull all the results to the top of the column, in order to save space when printing. I am trying to get the result to look something like this:
<tbody>
</tbody>
The problem I have run into with using INDEX/MATCH is that they don't carry over conditional formatting, which I need conserved. I'm assuming VBA code is needed for this, but I do not have enough knowledge in that area to be able to apply it. Any help is greatly appreciated!
First post here, hopefully it's in the right spot. I have been scouring the forum looking for a solution to this problem, but to no avail so far.
Basically, I have a workbook that visually reports the Fiscal Year status of our product in the field. The Fiscal Years run from FY 11 to FY 30. The product version is set to automatically change based on the value in a separate spreadsheet, and conditionally change color based on said value. This works fine, and is accomplished by a simple IF statement/formula shown below:
=IF('Fielding Plan '!$D11="Upgrade","CXG 1","")
The problem, however, comes next. Taking a portion of the workbook as an example, the status of our product may look like this:
| FY 11 | FY 12 | FY 13 | FY 14 | FY 15 | FY 16 | |
| CXG 1 | ||||||
| CXG 2 | ||||||
| CXG 3 | ||||||
| CXG 4 |
<tbody>
</tbody>
This is done to multiple versions of our product, not just CXG. So what I am trying to accomplish, is to pull all the results to the top of the column, in order to save space when printing. I am trying to get the result to look something like this:
| FY 11 | FY 12 | FY 13 | FY 14 | FY 15 | FY 16 |
| CXG 1 | CXG 2 | CXG 4 | |||
| CXG 3 | |||||
<tbody>
</tbody>
The problem I have run into with using INDEX/MATCH is that they don't carry over conditional formatting, which I need conserved. I'm assuming VBA code is needed for this, but I do not have enough knowledge in that area to be able to apply it. Any help is greatly appreciated!
