Conditional Formatting of a stacked chart that adds YTD totals

[chi1wxc]

Trying to Conditional format a Stacked graph for a YTD total. Sample data is below:

[TABLE="width: 650"]
<tbody>[TR]
[TD="width: 84, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: #E4DFEC"]Jan[/TD]
[TD="width: 68, bgcolor: #E4DFEC"]Feb[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Mar[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Apr[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]May[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Jun[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Jul[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Aug[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Sep[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Oct[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Nov[/TD]
[TD="width: 64, bgcolor: #E4DFEC"]Dec[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Target[/TD]
[TD="bgcolor: transparent"] 506 [/TD]
[TD="bgcolor: transparent"] 476 [/TD]
[TD="bgcolor: transparent"] 491 [/TD]
[TD="bgcolor: transparent"] 495 [/TD]
[TD="bgcolor: transparent"] 501 [/TD]
[TD="bgcolor: transparent"] 489 [/TD]
[TD="bgcolor: transparent"] 508 [/TD]
[TD="bgcolor: transparent"] 503 [/TD]
[TD="bgcolor: transparent"] 519 [/TD]
[TD="bgcolor: transparent"] 487 [/TD]
[TD="bgcolor: transparent"] 471 [/TD]
[TD="bgcolor: transparent"] 517 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2018 AOP[/TD]
[TD="bgcolor: transparent"] 506 [/TD]
[TD="bgcolor: transparent"] 476 [/TD]
[TD="bgcolor: transparent"] 491 [/TD]
[TD="bgcolor: transparent"] 495 [/TD]
[TD="bgcolor: transparent"] 501 [/TD]
[TD="bgcolor: transparent"] 489 [/TD]
[TD="bgcolor: transparent"] 508 [/TD]
[TD="bgcolor: transparent"] 503 [/TD]
[TD="bgcolor: transparent"] 519 [/TD]
[TD="bgcolor: transparent"] 487 [/TD]
[TD="bgcolor: transparent"] 471 [/TD]
[TD="bgcolor: transparent"] 517 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2018 Act[/TD]
[TD="bgcolor: transparent"] 541 [/TD]
[TD="bgcolor: transparent"] 476 [/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Above AOP[/TD]
[TD="bgcolor: transparent"] 541 [/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[TD="bgcolor: transparent, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Below AOP[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]476[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]

The above table will only graph either the "Above AOP" or the "Below AOP", but not the Total YTD. (See graph below:


Is there a solution that will conditional format "ACT" where any "Actual" YTD total value above the YTD target is "Red" and below is "Green"?

 

[DanteAmor]

The image can not be seen.
You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-adds-ytd-totals-post5249745.html#post5249745

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).