Ask Your Question

1 cell = many cells filled [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-14 23:01:03.456318

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

Question Tools

1 follower


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

Seen: 70 times

Last updated: Sep 07 '17