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

If I have:

A =A6 B =A6 C =A6 D =A6 E =A6 F =A6 G =A6 H =A6 I =A6 J =A6 K =A6=
L =A6 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



<[email protected]> wrote in message
news:[email protected]...
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)

<[email protected]> wrote in message
news:[email protected]...
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


[email protected] wrote:

> If I have:
>
> A =A6 B =A6 C =A6 D =A6 E =A6 F =A6 G =A6 H =A6 I =A6 J =A6 K =
=A6 L =A6 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.
>=20
> Any ideas?
>=20
> Thanks

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

HTH
--
AP

<[email protected]> a écrit dans le message de news:
[email protected]...
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)
> Format>Conditional Format> Formula is
> =3DAND($a1<>"",$b1<>"",$c1<>"",$c1<>"",$D1<>"",$e1<>"",$f1<>"",$g1<>"",$h=
1<>"",$i1<>"",$j1<>"",$k1<>"",$l1<>"",$m1<>"")
>
> HTH
> --
> AP
>
> <[email protected]> a =E9crit dans le message de news:
> [email protected]...
> If I have:
>
> A =A6 B =A6 C =A6 D =A6 E =A6 F =A6 G =A6 H =A6 I =A6 J =A6 K =
=A6 L =A6 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.
>=20
> Any ideas?
>=20
> Thanks

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

Cheers,
--
AP

<[email protected]> a écrit dans le message de news:
[email protected]...
Thanks for all the suggestions, Ardus' solution worked really well.



Ardus Petus wrote:

> Select the desired range (ie A1:M999)
> Format>Conditional Format> Formula is
> =AND($a1<>"",$b1<>"",$c1<>"",$c1<>"",$D1<>"",$e1<>"",$f1<>"",$g1<>"",$h1<>"",$i1<>"",$j1<>"",$k1<>"",$l1<>"",$m1<>"")
>
> HTH
> --
> AP
>
> <[email protected]> a écrit dans le message de news:
> [email protected]...
> 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