Dude, you are a life saver. I spent two weeks trying to figure out a solution to a problem, but couldn't find it anywhere until seeing this video. Specifically, it was how to format conditional formatting for a string. Thank you so much for the help you provided.
Hi, thank you for your useful tutorial. Is it possible to apply a conditional format to a range of cells, but only every other row? My goal is to be able to apply a background color to every other row in an Excel table in order to make it easier to read. I tried this: conditionalFormatting(wb, "sheet1", cols = 2, rows = seq(1, 100, by = 2), rule = "A1=A1", style = greyStyle) NB: the rule "A1=A1" is here to make it always true. But it doesn't work, all the cells in the range are colored grey. Thanks in advance if you can help.
Hi, Can you please take a look at GOplot, it will be really helpful if you can explain how the EC.rda file is generated from the beginning. I am about to cry because of all the errors. Thank you. :)
![Add Comments to Excel with RStudio and openxlsx package [4k]](http://i.ytimg.com/vi/JVeIVk8hymM/mqdefault.jpg)
![Add Comments to Excel with RStudio and openxlsx package [4k]](/img/tr.png)
Dude, you are a life saver. I spent two weeks trying to figure out a solution to a problem, but couldn't find it anywhere until seeing this video. Specifically, it was how to format conditional formatting for a string. Thank you so much for the help you provided.
every time I have a question, you have the answer! Thanks a million!
Glad I could help. It's been a while since I uploaded anything. Hopefully I can answer more questions now that I am up and running again.
I was looking for a quick tutorial/introduction to 'openxlsx' and this was just great for that. Thanks. I'll subscribe.
Fabulous, thank you so much this has been a great help.
Thanks for this. Do you have anything on conditionally formatting the output of a dplyr filter command? Thanks
I have one video on conditional formatting, check out th-cam.com/video/ACdCQuQJxhU/w-d-xo.html . Let me know if this helps.
Great tutorial! Thanks
No problem. I need to get to doing more of these videos soon.
Hi, thank you for your useful tutorial. Is it possible to apply a conditional format to a range of cells, but only every other row? My goal is to be able to apply a background color to every other row in an Excel table in order to make it easier to read.
I tried this: conditionalFormatting(wb, "sheet1", cols = 2, rows = seq(1, 100, by = 2), rule = "A1=A1", style = greyStyle)
NB: the rule "A1=A1" is here to make it always true.
But it doesn't work, all the cells in the range are colored grey. Thanks in advance if you can help.
Is there any way to do this with a formula for the rule? Doesn't seem to work with an IF statement
Could you use a rule to apply conditional formatting based on values in another row?
Hi,
Can you please take a look at GOplot, it will be really helpful if you can explain how the EC.rda file is generated from the beginning.
I am about to cry because of all the errors.
Thank you. :)
what if instead of rows = 1:26, I have unknown # of rows...what will be the argument?
hello, if you want to apply it to all rows it'll be rows= 1:nrow(name of variable)
I don't think this works for numFmt in createStyle. It's really frustrating.