# Calc VBA Macro: Any way to conditionally format text color? [closed]

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 (4.3.2.2), 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 _
'.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.
'423'
FormatConditions

So, I'm assuming that FormatConditions is Excel specific? If so, is there a way to use styles in conjunction with a condition?

edit retag reopen merge delete

### Closed for the following reason question is not relevant or outdated by JohnSUN close date 2018-09-20 07:31:26.892549

any silly code compile and runif you 'comment out all the stuff