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

Conditional Formatting

Sowmyasaidam

New Member
Hi . For Eg : Sales for Current week =100
Sales for Previous week = 50
Now Im preparing a report showing only Current week column and hide the Previous week column. Now While showing current week i need to show the trend comparing with Previous week with Increase (or) Decrease using Icon set conditional formatting.
I selected a Rule type =" Format all cells based on their values" and selected my icon style with arrows . Now in type section i selected Formula and gave formula as =Indirect(address(Row()+1,Column()) .
Though im getting the arrows but its not right .
Can one help on this .
Attached excel for reference
 

Attachments

  • New Microsoft Excel Worksheet (2).xlsx
    8.8 KB · Views: 6
Back
Top