databarExample.xlsx example compiles, but cannot be opened

[badgettrg]

I copy the code from the conditionalFormattingExample.xlsx example at https://ycphs.github.io/openxlsx/reference/conditionalFormatting.html into R studio. The code, even after deleting the lines involving blank characters that have the known bug, the resulting xlsx cannot be opened by xsl which stated "We found a problem with some content..."

My specific question is about: highlight cells in column 1 based on value in column 2

• If the rule applies to all rows and is based on containing text in column b, how is the rule written? None of the following variations seem to work:

rule = "B1>=string" rule = "B1>='string'" rule = "$B1>=string" rule = "$B$1>=string"

Great package. thanks,