• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

DashBoard to have trend in Excel 2007

B

Bhineet

New Member
Hi !

I am looking for solution where conditional formatiing like Trend marking ( red Green and Amber ) or Three arrow defines the trend ONLY ON Current month column , while trending comes from last three months.

Say there are five parameters and data is available for last three months.

In the current months column there should be indicator based on the defined criteria ( lower the Better or Higher the Better ).
 
Hi Bhineet..

Can you please upload a sample file with expected output..

BTW, Conditional Formatting with ICON's, never works with Relative Reference. By seeing your upload, we may able to create some workaround..
 
Uploaded the file ..

Conditional formatting gives the indication on all three but need to have indictor only on last column of march based on the values of Jan and Feb .
 

Attachments

Debraj said:
Hi Bhineet..

Can you please upload a sample file with expected output..

BTW, Conditional Formatting with ICON's, never works with Relative Reference. By seeing your upload, we may able to create some workaround..
Click to expand...

Uploaded the file earlier too. Looking for your support
 

Attachments

You must log in or register to reply here.
Back
Top