Dan in Lowell
New Member
- Joined
- Sep 29, 2006
- Messages
- 14
Hi,
I have a spreadshhet in which activities are listed one per row and there are data elements in columns a through r for each item. In column G is a status indicator which is selected from a drop down menue so as to ensure the consitancey of the status spelling etc.
I would like to apply conditional formatting that will color each row a different color depending on the status indicator. (e.g: Pending status = blue, Completed = yellow, etc.) I would like the formatting to not go beyond the R column so that the remaining empty column beyond column r are never considered in the print range by virtue of having been formatted.
Thanks in advance for your help.
I have a spreadshhet in which activities are listed one per row and there are data elements in columns a through r for each item. In column G is a status indicator which is selected from a drop down menue so as to ensure the consitancey of the status spelling etc.
I would like to apply conditional formatting that will color each row a different color depending on the status indicator. (e.g: Pending status = blue, Completed = yellow, etc.) I would like the formatting to not go beyond the R column so that the remaining empty column beyond column r are never considered in the print range by virtue of having been formatted.
Thanks in advance for your help.