If I have:

A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ I ¦ J ¦ K ¦ L ¦ M

------------------------------------------------------------
row 1
row 2


Once all cells in row 1 (from A1 to M1) have something inside, I want
the row to change color.

I also want this conditional formatting to apply to every subsequent
row in the sheet as more info is added.

Any ideas?

Thanks

Select all the target rows, saying starting at 2 (it reflects in the
formula)

Enter CF

Change Condition 1 to Formula Is

Add a formula of

=COUNTBLANK(2:2)=0

and add a colour from the pattern tab

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
If I have:

A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ I ¦ J ¦ K ¦ L ¦ M

------------------------------------------------------------
row 1
row 2


Once all cells in row 1 (from A1 to M1) have something inside, I want
the row to change color.

I also want this conditional formatting to apply to every subsequent
row in the sheet as more info is added.

Any ideas?

Thanks

Hi Carlosven,

Select the range A1:M100 and use the CF formula:

=COUNTA($A1:$M1)=13

Adjust the range as required.


---
Regards,
Norman



wrote in message
ups.com...
If I have:

A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ I ¦ J ¦ K ¦ L ¦ M

------------------------------------------------------------
row 1
row 2


Once all cells in row 1 (from A1 to M1) have something inside, I want
the row to change color.

I also want this conditional formatting to apply to every subsequent
row in the sheet as more info is added.

Any ideas?

Thanks

Do you have headings only from A to M?

like
Head1 Head2 Head3 etc up to M only then blank
row1
row2
etc

Duncan


wrote:

If I have:

A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ I ¦ J ¦ K ¦ L ¦ M

------------------------------------------------------------
row 1
row 2


Once all cells in row 1 (from A1 to M1) have something inside, I want
the row to change color.

I also want this conditional formatting to apply to every subsequent
row in the sheet as more info is added.

Any ideas?

Thanks

Select the desired range (ie A1:M999)
FormatConditional Format Formula is
=AND($a1<"",$b1<"",$c1<"",$c1<"",$D1<"",$e1< "",$f1<"",$g1<"",$h1<"",$i1<"",$j1<"",$k1<"" ,$l1<"",$m1<"")

HTH
--
AP

a écrit dans le message de news:
...
If I have:

A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ I ¦ J ¦ K ¦ L ¦ M

------------------------------------------------------------
row 1
row 2


Once all cells in row 1 (from A1 to M1) have something inside, I want
the row to change color.

I also want this conditional formatting to apply to every subsequent
row in the sheet as more info is added.

Any ideas?

Thanks

Thanks for all the suggestions, Ardus' solution worked really well.



Ardus Petus wrote:

Select the desired range (ie A1:M999)
FormatConditional Format Formula is
=AND($a1<"",$b1<"",$c1<"",$c1<"",$D1<"",$e1< "",$f1<"",$g1<"",$h1<"",$i1<"",$j1<"",$k1<"" ,$l1<"",$m1<"")

HTH
--
AP

a écrit dans le message de news:
...
If I have:

A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ I ¦ J ¦ K ¦ L ¦ M

------------------------------------------------------------
row 1
row 2


Once all cells in row 1 (from A1 to M1) have something inside, I want
the row to change color.

I also want this conditional formatting to apply to every subsequent
row in the sheet as more info is added.

Any ideas?

Thanks

Bob's and Norman's solution are much smarter than mine!
Don't they work?

Cheers,
--
AP

a écrit dans le message de news:
...
Thanks for all the suggestions, Ardus' solution worked really well.



Ardus Petus wrote:

Select the desired range (ie A1:M999)
FormatConditional Format Formula is
=AND($a1<"",$b1<"",$c1<"",$c1<"",$D1<"",$e1< "",$f1<"",$g1<"",$h1<"",$i1<"",$j1<"",$k1<"" ,$l1<"",$m1<"")

HTH
--
AP

a écrit dans le message de news:
...
If I have:

A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ I ¦ J ¦ K ¦ L ¦ M

------------------------------------------------------------
row 1
row 2


Once all cells in row 1 (from A1 to M1) have something inside, I want
the row to change color.

I also want this conditional formatting to apply to every subsequent
row in the sheet as more info is added.

Any ideas?

Thanks