Ask Your Question

1 cell = many cells filled

asked 2017-09-06 00:08:32 +0100

simontfs gravatar image

updated 2017-09-07 19:29:00 +0100

If cell A1=10 how can I make calc fill cells B1 to B10 in red Or if cell C1=Tom and cell C2=10 how can I make cell D5 to D15 fill in red and the name "Tom"

Can this be done?.. thanks for the help...totally loving calc.Amazing alternative to excel.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-06 06:40:40 +0100

JBF gravatar image

Add a formula like =$A$1 in B1 to B10 and add a style writing in red. For more complex conditions uses the function IF()

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2017-09-06 00:08:32 +0100

Seen: 44 times

Last updated: Sep 07 '17