Looks like has nearly worked, thank you. I need the colouringto start from A17 now, if possibleHow about
+Fluff v2.xlsm
A B C 1 2 3 4 5 6 7 8 9 10 7 11 12 13 14 15 16 17 18 19 20 21 Main
Cells with Conditional Formatting Cell Condition Cell Format Stop If True A1:A20 Expression =ROW()<=$C$10 text NO
Great, I'll have a tinker...... thank youIn that case select A17 downwards & useExcel Formula:=ROW()-16<=$C$10