Auto Aoloring of cells and text

Venkatesh - Sep 4, 2009 at 10:01 AM
 Blocked Profile - Sep 4, 2009 at 10:39 AM

I have the following requirement:

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!

1 response

Blocked Profile
Sep 4, 2009 at 10:39 AM
Hye you can try it by creating a macro for OOC,