Posted to microsoft.public.excel.programming
|
|
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
|