In calc, how do I set conditional fomat to say if cell value less than RC[1] then use red text in a macro.

asked 2021-01-02 04:04:37 +0100

MikeMcClain46 gravatar image

I'm converting a stock tracking spreadsheet from Excel to LO Calc and having trouble with coloring cells based on their value based on their relationship to other cells values. In digging through the docs I see I should define a style but am unclear how to do so programmatically. Likewise my Excel code dies on ActiveCell.FormatConditions.Delete. How do you go about clearing the previous conditional format? Thanks, Mike

Your site needs work if I have to solve 'NotARobot' 5 times just to post a question.

edit retag flag offensive close merge delete

Comments

Your site needs

It is not "Our", since we are users of LibreOffice like you are a user of LibreOffice

Opaque gravatar imageOpaque ( 2021-01-02 12:36:09 +0100 )edit