Introduction to condformat

Sergio Oller 2020-05-14

condformat renders a data frame in which cells in columns are formatted according to several rules or criteria.

Downloads Build Status

Browse source code

Checkout the code and browse it at

How to install condformat:


If you want to use the PDF output you will need the xcolor LaTeX package. Either use the full texlive distribution, or install latex-xcolor on Debian and derivatives.

Package installation


condformat(iris[c(1:5,70:75, 120:125),]) %>%
  rule_fill_discrete(Species) %>%
  rule_fill_discrete(c(Sepal.Width, Sepal.Length),
                     expression = Sepal.Width > Sepal.Length - 2.25,
                     colours = c("TRUE" = "#7D00FF")) %>%
  rule_fill_gradient2(Petal.Length) %>%
  rule_text_bold(c(Sepal.Length, Species), Species == "versicolor") %>%
                  expression = ifelse(Species == "setosa", "yellow", "")) %>%
  rule_fill_bar(Petal.Width, limits = c(0, NA)) %>%
  theme_grob(rows = NULL) %>%

This example covers most of the condformat rules.

Rules and output engine support

Rule HTML LaTeX gtable Excel
rule_fill_discrete X X X X
rule_fill_gradient X X X X
rule_fill_gradient2 X X X X
rule_text_color X X X X
rule_text_bold X X X X
rule_fill_bar X X
rule_css X