Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |