1 cell = many cells filled

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.

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()