|||

Unlimited conditional formats in openoffice spreadsheet

It’s annoying that openoffice, and I believe Excel too, limits you to just three formats which can be applied through conditional formatting.
For example, in my evaluation work, I have a column of phrases which i want to format each with one of five different formats, according to the number (from 1 to 5) in the column to the left.
But it isn’t impossible, … I just found a beautiful solution here.
Actually I simplified that solution even further, like this:
All you have to do is, in the conditional formatting dialogue, switch the dropdown to formula is” and paste in this: CHOOSE(condition,STYLE(“1”),STYLE(“2”),STYLE(“3”),STYLE(“4”),STYLE(“5”)), where _1, _2 are the names of styles defined in your sheet and condition is some condition which evaluates to a number from 1 to 5. Obviously there is no limit to the number of styles.
It doesn’t matter what style you choose in the Cell style” dropdown.
And that’s it.

Up next Problems with R Struggling for two whole days to do some not-terribly-advanced repeated-measures analysis of variance in R. Probably my worst experience with R so Three days, six people, three pages, one google doc Just got back from Geneva where we - the four authors of the meta-evaluations of the ARC Tsunami Recovery Program - spent three days writing a
Latest posts Causal Mapping - an earlier guide The walk to school in Sarajevo Glitches Draft blog post for AEA365 Theory Maker! Inventory & analysis of small conservation grants, C&W Africa - Powell & Mesbach! Lots of charts! Answering the “why” question: piecing together multiple pieces of causal information rbind.fill for 1-dimensional tables in r yED graph editor Examples of trivial graph format Using attr labels for ggplot An evaluation puzzle: “Talent show” An evaluation puzzle: “Mobile first” An evaluation puzzle: “Many hands” An evaluation puzzle: Loaves and fishes An evaluation puzzle: “Freak weather” An evaluation puzzle: “Billionaire” Publications Using Dropbox for syncing Shiny app data on Amazon EC2 Progress on the Causal Map app Articles and presentations related to Causal Maps and Theorymaker Better ways to present country-level data on a world map: equal-area cartograms A starter kit for reproducible research with R A reproducible workflow for evaluation reports Welcome to the Wiggle Room Realtime comments on a Theory of Change Responses to open questions shown as tooltips in a chart A panel on visualising Theories of Change for EES 2018? Peer mentoring for evaluators How do you explain reproducible research to clients? Links for my AEA eval2017 presentation, Washington DC