Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Placing Icons
Hi
I'm facing a problem from last month but I'm not able to put Icons whether it can be done through conditional formatting or through a macro. If somebody can help as its really urgent for me !!!!! I have values for two months - Current and Previous. If current month's value is closer to zero than previous month's value then i want to show a green arrow. If current month's value is away from zero than previous month's value then i want to show a red arrow. Though these values are positive and negative both, i need to apply conditional formatting on absolute values. e.g. previous Current Arrow Colour 1.2% 2.4% Red Arrow 1.2% -2.4% Red Arrow -1.2% 2.4% Red Arrow -1.2% -2.4% Red Arrow -2.4% 1.2% Green Arrow -2.4% -1.2% Green Arrow 2.4% -1.2% Green Arrow 2.4% 1.2% Green Arrow But the conditional formatting will be applied on absolute values and I want to put the condition in same cell in which the current month values are shown. I tried it with conditional formatting but not able to get the desired result. Any help will be appreciated.. Regards, Miki |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform - placing | Excel Programming | |||
Placing an UDF | Excel Worksheet Functions | |||
placing.. 1st, 2nd, 3rd... | Excel Discussion (Misc queries) | |||
Placing bubbles | Charts and Charting in Excel | |||
placing | Excel Worksheet Functions |