LinkBack URL
About LinkBacks
Hi There, could someone help me writing the IF statement that will apply green arrow up image when variance is greater than 0 and red arrow down image to negative variance?
Thanks!
Hi There, could someone help me writing the IF statement that will apply green arrow up image when variance is greater than 0 and red arrow down image to negative variance?
Thanks!
You could use CF. For example, select the cells, choose CF / Icon Sets / More Rules... and then set the icon for > 0 to green arrow, and <0 to a red arrow.
Last edited by Bernie Deitrick; 09-09-2014 at 01:36 PM.
Bernie Deitrick
Excel MVP 2000-2010
Hi Bernie,
The problem is that I want to use the images cause they are much sleeker. Do you know how to do that?
Thank you for the replay!
Conditional Formatting is designed for this, and will be much simpler
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
ok, thank you.
Insert your two pictures onto the worksheet, and name them UpArrow and DownArrow
Then copy this code, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Then save the workbook as a macro-enabled .xlsm file. Change the "B:B" to the range of cells with the variance formulas.
Please Login or Register to view this content.
Bernie, it works for UpArrow but not for DownArrow, but probably I am not running this code correctly. And just one more question, how to place the arrows in C column next to variances in B? thanks
It should work for both - can you post your file?
To place the pictures in the next column, use r(1,2) instead of r, like
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks