colour changes

ivor31

Member
80 1
Hi
Ive managed to change the colour in net change for green above zero val and red below zero val. [green]+#.0;[red]-#.0
How would i write a format that would also change the bid/ask to calcutate green if higher then last quote or red if lower than last quote.Any help appreciated.
Thanks
 

knorrie

Active member
148 1
You can't, the built-in Sierra spreadsheet only does conditional formatting based on the actual cell value, unlike Excel which also allows formulas.

KenN
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock