Thread
:
Color all cells in a row if row is completely filled?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Duncan[_5_]
external usenet poster
Posts: 290
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
Reply With Quote
Duncan[_5_]
View Public Profile
Find all posts by Duncan[_5_]