Forum

Notifications
Clear all

If condition - colored Sparkline

3 Posts
2 Users
0 Reactions
808 Views
(@alexpguerra)
Posts: 2
New Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
(@alexpguerra)
Posts: 2
New Member
Topic starter
 

Thank you Mynda,

Conditional formatting done successfully.

Sample attached.

 

Best regards,

Alex

 
Posted : 07/12/2022 1:27 pm
Share: