If the value in cell A1 is greater than 0, then the same value should be displayed in cell A2 with the background being GREEN IN COLOR. Is it possible in open office calc?
I have checked the conditional formatting in OOC but found that it can format only the font of the cells (in this case A2) and not color the cells as desired. Am I missing something? I am using OOC on windows Vista!