Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Increases/Decreases
Dear All,
I am creating a set of price lists and want to use conditional formatting to show if the cost of a product has increased or decreased in price. I have managed to get the formula to work and have managed to get the icons to display the correct way but one thing that is frustrating me is the icons colouring. I want to highlight the changes and show a downward arrow, a decrease in price as a green arrow (good), and I want to show and increase in price as a red upward arrow (bad). The only icons in excel are the opposite way round, red down, green up. Is there any way of changing this icons? edit there colours? Is there a way of using my own icons? Thanks, Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Increases/Decreases
Hi,
I think you are in luck: Select the range that is already formatted and choose Home, Conditional Formatting, Manage Rules, select the rule and choose Edit Rule, at the bottom of the dialog box check the Reverse Icon Order If this helps, please check the Yes button. -- Thanks, Shane Devenshire "Paul Lambourne" wrote: Dear All, I am creating a set of price lists and want to use conditional formatting to show if the cost of a product has increased or decreased in price. I have managed to get the formula to work and have managed to get the icons to display the correct way but one thing that is frustrating me is the icons colouring. I want to highlight the changes and show a downward arrow, a decrease in price as a green arrow (good), and I want to show and increase in price as a red upward arrow (bad). The only icons in excel are the opposite way round, red down, green up. Is there any way of changing this icons? edit there colours? Is there a way of using my own icons? Thanks, Paul |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Increases/Decreases
if you are using excel 07,
go to the conditional formatting and icons, choose 'more rules' at the bottom of the list. then, choose 3 arrows colored, (at the bottom of the window) now you can choose when to show which arrow. (with your choise) "Paul Lambourne" wrote: Dear All, I am creating a set of price lists and want to use conditional formatting to show if the cost of a product has increased or decreased in price. I have managed to get the formula to work and have managed to get the icons to display the correct way but one thing that is frustrating me is the icons colouring. I want to highlight the changes and show a downward arrow, a decrease in price as a green arrow (good), and I want to show and increase in price as a red upward arrow (bad). The only icons in excel are the opposite way round, red down, green up. Is there any way of changing this icons? edit there colours? Is there a way of using my own icons? Thanks, Paul |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Increases/Decreases
sorry missed one,
you also need to check "reverse icon order" in the more rules window. "Paul Lambourne" wrote: Dear All, I am creating a set of price lists and want to use conditional formatting to show if the cost of a product has increased or decreased in price. I have managed to get the formula to work and have managed to get the icons to display the correct way but one thing that is frustrating me is the icons colouring. I want to highlight the changes and show a downward arrow, a decrease in price as a green arrow (good), and I want to show and increase in price as a red upward arrow (bad). The only icons in excel are the opposite way round, red down, green up. Is there any way of changing this icons? edit there colours? Is there a way of using my own icons? Thanks, Paul |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Increases/Decreases
Hi,
Thanks for the suggestions, I am pretty sure that I have tried reversing the icons but all it does is reserve their use. The red DOWN arrow is shown for an increase and the green UP is used for a decrease. What I want is to have a RED UP and GREEN DOWN? Is there any way of using custom icons? Thanks. Paul "Raz" wrote: sorry missed one, you also need to check "reverse icon order" in the more rules window. "Paul Lambourne" wrote: Dear All, I am creating a set of price lists and want to use conditional formatting to show if the cost of a product has increased or decreased in price. I have managed to get the formula to work and have managed to get the icons to display the correct way but one thing that is frustrating me is the icons colouring. I want to highlight the changes and show a downward arrow, a decrease in price as a green arrow (good), and I want to show and increase in price as a red upward arrow (bad). The only icons in excel are the opposite way round, red down, green up. Is there any way of changing this icons? edit there colours? Is there a way of using my own icons? Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation list decreases as the user chooses from the list/s | Excel Discussion (Misc queries) | |||
formula for 2% annual sales increases | Excel Worksheet Functions | |||
How can I increase value in one cell as value in other decreases? | New Users to Excel | |||
Salary and Pension Increases | Excel Discussion (Misc queries) | |||
How can I update pricebook increases in different percentages | Excel Worksheet Functions |