Automatic style changes in calc

[saji]

How the style of one cell can be automatically changed depending upon the style of another cell. For Eg.: I have defined styles in Cell A1 using conditional formating and I want the same style in BI. Now, When any style changes in A1 happens, the same style change should automatically reflect in B1 also.

thanks in advance. for any help

-saji

[w_whalley]

Use a conditional formatting formula in cell B1 and set the same condition as the cell value condition in A1.

For example if you set style “red” for cell A1 when the condition is Cell Value greater than 0, then in cell B1 set the style as “red” when the Formula condition is A1>0.