From: Miki on 6 Mar 2010 03:53 Hi I'm facing a problem from last month but I'm not able to put conditional formatting with Icons. 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. Any help will be appreciated.. Regards, Miki From: Mike H on 6 Mar 2010 05:10 see your other post -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Miki" wrote: > Hi > > I'm facing a problem from last month but I'm not able to put conditional > formatting with Icons. > > 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. > > Any help will be appreciated.. > > Regards, > Miki >  |  Pages: 1 Prev: Finding Average of last 5 entriesNext: protection indicator