I am in charge of generating and maintaining excel documents at work, and I have created a few robust macros in which our company will use. I originally created the macros in excel, but we now have began a migration to Libreoffice.
The macros themselves are simple enough, so aside from the conditional formatting issue, they work flawlessly.
It seems in the version of LibreOffice I have (126.96.36.199), I am able to create the condition, however I am not able to alter any attributes. For example:
With Range("C14:Q14, C19:Q19, C23:Q23, T14, T19, T23").FormatConditions _ .Add(xlCellValue, xlLess, 0.95) '.Font.Color = RGB(190, 0, 0) ''.Font.Bold = True End With
This code compiles, and runs, so I am assuming that I am successfully defining a condition , but as soon as I remove the singe quotes, I receive an error:
BASIC runtime error.
So, I’m assuming that FormatConditions is Excel specific? If so, is there a way to use styles in conjunction with a condition?