Macro to change row color once row is completed

[Cornerstone5576]

I need a macro that will recognize when every cell in a row is filled in (from column A to N) and then change that row color to green. This is for a worksheet that I would like to have change row color once each row has been fully completed by the end user. If there are any blanks in the row it must not change color.

Any help would be greatly appreciated, Thanks.

 

[VoG]

This can be done using Conditional Formatting: select the range, Format > Conditional Formatting, use the Formula Is option on the dropdown and use the formula below

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	3	4	76	83	99	94	73	88	81	90	11	89	47	63
2	81	8	45		100	26	47	1	63	88	28	61	2	60
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =COUNTA($A1:$N1)=14	Abc

 

[Cornerstone5576]

Thanks!, that works. Very simple.