Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Conditional Formatting in Pivot Based on other values in pivot. XL

I'm having problem with Conditional formatting in a pivot table.
The pivot is connected to an OLAP db (SSAS).

The values looks like this.
VALUE 45,00 28,20 47,25
Accepted VALUE 60,00 55,00 40,00
Critical VALUE 39,00 30,00 25,00

I'd like to set the conditional formatting on the VALUE.
Using "traffic lights" it should be green if it is larger than (=) the
Accepted VALUE, yellow if it is larger than (=) the critical and red if
lower.

I have tried with an icon set using the formulas
=INDIRECT("R[+1]C";FALSE)
and
=INDIRECT("R[+2]C";FALSE)
(setting the types to numbers) to get the two values below the VALUE in the
pivot.

This gives me the strangest bug.
The icon rule is formatted based on which cell I select, inside or outside
the pivot table (?).
If I select an empty cell outside the pivot they all turn green but if I
just enter random numbers outside the pivot and select the cell above or if I
select a cell inside the pivot with numbers in the cells below, the rule is
set according to the values.

Can anyone help me with this? Macro or formula, all tips are appriciated.
Thanks,
Mats M

PS. If it is to any help; The VALUE is a calculated member and the limits
are measures in the cube.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting in a pivot table Julie Excel Discussion (Misc queries) 2 September 27th 07 04:33 PM
Conditional Formatting in Pivot Table peter Excel Worksheet Functions 1 June 29th 07 04:16 PM
Conditional formatting in pivot tables? MLK Excel Discussion (Misc queries) 4 June 11th 07 12:49 AM
Conditional values based on formatting? lerjia Excel Worksheet Functions 2 May 22nd 07 07:18 PM
Is it possible to add conditional formatting in a pivot-table? Saddy Excel Discussion (Misc queries) 1 July 4th 06 06:28 PM


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"