View Single Post
 
Old 02-17-2019, 06:06 AM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
 
Join Date: Mar 2015
Posts: 79
Haha88 is on a distinguished road
Default Condition Icon setting help _ signage doesn't change

Hi,

I tried to condition formatting to include icons to the below data:

Forecast LV Budget vs Budget % TTLY vs TTLY %
128467 128467 129005 -0.4% 119117 7.9%

ie: upward green arrow to vs TTLY % as it's positive and downward red arrow apply to vs Budget % as is negative.

I tried changing the new setting but can only have either green or red on both. Hope someone can shed some lights.

I include the example sheet.

Many thanks in advance.

Ha.
Attached Files
File Type: xlsx Icon set up.xlsx (9.7 KB, 11 views)
Reply With Quote