Ask Your Question

automatic style changes in calc [closed]

asked 2012-11-20 12:09:11 +0100

saji gravatar image

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


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 02:20:30.847072

1 Answer

Sort by » oldest newest most voted

answered 2012-11-20 16:08:34 +0100

w_whalley gravatar image

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.

edit flag offensive delete link more

Question Tools


Asked: 2012-11-20 12:09:11 +0100

Seen: 87 times

Last updated: Nov 20 '12