Many thanks P45cal.
I am thinking of replacing these 2 lines. Over time, I may forget that I need to format a cell in the range and still wonder why the value is changing.
You're awesome, I'm just at a loss for words.....
P.S - However, when I delete the first 2 lines and replace them with the second suggestion, it gives me an error and refuses to run the macro.
Apparently I'm doing something wrong or I didn't understand it...
v.Offset(1).Copy 'deleted this
cll.PasteSpecial Paste:=xlPasteFormats 'deleted this
cll.Interior.Color = v.Offset(1).Interior.Color 'I put this one
cll.Font.Bold = v.Offset(1).Font.Bold 'and this one