Color all cells in a row if row is completely filled?
 

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

Color all cells in a row if row is completely filled?
 

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

Color all cells in a row if row is completely filled?
 

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

Color all cells in a row if row is completely filled?
 

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

Color all cells in a row if row is completely filled?
 

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

Color all cells in a row if row is completely filled?
 

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

Color all cells in a row if row is completely filled?
 

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