MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Conditional Formatting Query

• Follow

```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

```
 0

```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
>
```
 0

1 Replies
337 Views

Similiar Articles:

7/30/2012 9:44:21 AM