Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Query
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Query
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting a Report based on a query | Excel Discussion (Misc queries) | |||
Conditional Formatting Query | Excel Discussion (Misc queries) | |||
Conditional Formatting query | New Users to Excel | |||
Conditional formatting query | Excel Worksheet Functions | |||
How to preserve conditional formatting on a web query table result | Excel Discussion (Misc queries) |