[Solved] Change cell color, by comparing other cells

[rayroshi]

I am working on a budget spreadsheet, and simply want to compare two cells to each other: C10 ("Total Income") and C46("Total Expenses"); then if "Total Income," C10, is equal to or larger than "Total Expenses," C46, a third cell, C48 "Budget Surplus/Deficit," would be displayed in black; however if C10 is less than C46, cell C48 would change to red.

I have almost zero programming experience, so although this is a pretty basic thing for those who are experienced with Calc, I'm lost and would appreciate any help.

Additionally, if anybody knows of a good user manual that would help me learn how to use OpenOffice, I would also appreciate knowing what it is.

[FJCC]

This is easily done. I take it you want the value in C48 to be red or black, not the cell background. I'm assuming that C48 contains the difference of C10 and C46, so the number will be negative if C10 is less than C46. Click on C48 and then select the menu Format -> Cells. Choose the Numbers tab of the dialog. In the Category list, choose Currency. In the Format list, choose the item that is red and shows -$1,234.00. Click OK and you are done.

There are user guides for the old 3.3 version here.

[rayroshi]

Thank you for that helpful response; it worked perfectly. I really appreciate your time and effort!