I am trying to use openxlsx's conditionalformatting() function to highlight instances where, in my dataset, Notes Section 1 and Notes Section 2 BOTH are blank. Openxlsx's documentation--page 16-- says logical operators are possible (in this case AND), but I can't figure out how to properly type the syntax.
This is what I have:
conditionalFormatting(wb, "Sheet1", cols = 26:27, rows = 2:93, rule = 'AND(="")', style = redStyle) #Save Formatting Change saveWorkbook(wb, "Both_Notes_Blank.xlsx", TRUE)
Everything should be good to go EXCEPT the rule syntax. Anyone know how to format?