Auto Aoloring of cells and text [Closed]

Report
-
 Blocked Profile -
Hello,

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 reply


Hye you can try it by creating a macro for OOC,

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!