
Alexandre Guerra
New Member
Members

Forum Posts: 2
Member Since:
December 6, 2022
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,
Alex

Mynda Treacy
Admin

Forum Posts: 4506
Member Since:
July 16, 2010
July 16, 2010

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

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, Sharon Fletcher
Guest(s) 5
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
jo moffitt
Michael Zandt
Ibraam Nasif
Gali Balmocena
Jocelyn Degran
Nurul Amalina
Sarah Mooney
Gopinath Gopalan
Nick Pape
Fakhar Zaman
Forum Stats:
Groups: 3
Forums: 24
Topics: 6347
Posts: 27751
Member Stats:
Guest Posters: 49
Members: 32305
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
