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:

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Target

506

476

491

495

501

489

508

503

519

487

471

517

2018 AOP

506

476

491

495

501

489

508

503

519

487

471

517

2018 Act

541

476

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

Above AOP

541

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

Below AOP

#N/A

476

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

<tbody>
</tbody>

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).