December 6, 2022
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,
July 16, 2010
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.