No such thing as a small change | |
PerlMonks |
Spreadsheet::WriteExcel -> Conditional Formatting Colorsby sectokia (Pilgrim) |
on Jul 05, 2021 at 03:57 UTC ( [id://11134646]=perlquestion: print w/replies, xml ) | Need Help?? |
sectokia has asked for the wisdom of the Perl Monks concerning the following question: In the doc for 'Spreadsheet::WriteExcel' there this example for conditional color based on positive or negative percent value: $f_change->set_num_format('[Green]0.0%;[Red]-0.0%;0.0%');I would like to do something slightly different: Green if over 80%, orange if over 40%, otherwise red. However I cannot understand the syntax of the format string Everything I have tried results in excel complaining about the format and asking to recover the document :-( Any ideas? Thanks!
Back to
Seekers of Perl Wisdom
|
|