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

edit

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.