MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 348
- Office Version
- 2013
- Platform
- Windows
I have a worksheet that tables USD to CZK Exchange Rate Forecast for 2020 through 2025.
One column that comes in from USD to CZK Forecast: up to 24.843! Dollar to Koruna Analysis, Converter, Live Exchange Rates and Prediction, Long-Term & Short-Term Forex (FX) Prognosis shows percent change which includes the symbol ▲ if positive and the symbol ▼ if negative.
So any given cell in this column shows the value 0.78 % ▲ for positive and -0.63 %▼ for negative.
I have tried using conditional formatting with no success as the symbol seems to thwart the action.
Using conditional formatting I would like the positive cells to be green and the negative cells to be red which either case including the symbol.
I would think the parameters would be either the positive & negative status and/or the presence of the up or down symbol.
Anyone have a good solution in mind to accomplish this rather seemingly easy task?
Thanks for any help offered.
One column that comes in from USD to CZK Forecast: up to 24.843! Dollar to Koruna Analysis, Converter, Live Exchange Rates and Prediction, Long-Term & Short-Term Forex (FX) Prognosis shows percent change which includes the symbol ▲ if positive and the symbol ▼ if negative.
So any given cell in this column shows the value 0.78 % ▲ for positive and -0.63 %▼ for negative.
I have tried using conditional formatting with no success as the symbol seems to thwart the action.
Using conditional formatting I would like the positive cells to be green and the negative cells to be red which either case including the symbol.
I would think the parameters would be either the positive & negative status and/or the presence of the up or down symbol.
Anyone have a good solution in mind to accomplish this rather seemingly easy task?
Thanks for any help offered.