Auto change one cell's fill to match another cell

[spotta]

Hi

My wife has made me a lovely spreadsheet for my accounts. there is one column (K) that auto changes fill colour to show how overdue my customer is with paying me!!
I would like it that the other cells on the same row would match the fill colour of this cell but she does not know how to do this.

so if K14 was red then i would like K1 - K13 to also be red.

Can anyone provide me with a bit of help? version 2010

thanks.

[Fotis1991]

Hi and welcome to the forum.

In Conditional Formatting rules, just change the range, to $K$1:$K$13