Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
662
Views
Topic starter
Hi everyone, good day from Brazil.
Could someone help with this one?
How do I insert an "if" color condition to Sparkline?
I would like to have "red colored Sparkline" for every stock that have today price lower than -365 day price.
And a "green colored Sparkline" for every stock that have a today price higher than -365 price.
Attached is the sample portfolio spreadsheet I am using.
Thanks in advance,
Alex
Posted : 06/12/2022 2:36 pm
Hi Alex,
You can't conditionally format the Sparkline line. The best you could do is colour the cell fill for that Sparkline using conditional formatting. See this tutorial: conditional formatting with formulas.
Mynda
Posted : 06/12/2022 8:09 pm
Topic starter
Thank you Mynda,
Conditional formatting done successfully.
Sample attached.
Best regards,
Alex
Posted : 07/12/2022 1:27 pm
