<html>
<body>
Hey guys,
I hope you can help me out with this
I have a spreadsheet that looks like the following:</p>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="25%">A</td>
<td width="25%">B</td>
<td width="25%">C</td>
<td width="25%">D</td>
</tr>
<tr>
<td width="25%">Project</td>
<td width="25%">Status</td>
<td width="25%">Start Date</td>
<td width="25%">End Date</td>
</tr>
<tr>
<td width="25%">A</td>
<td width="25%">Closed</td>
<td width="25%">4/1/2007</td>
<td width="25%">5.1/2007</td>
</tr>
<tr>
<td width="25%">B</td>
<td width="25%">Open</td>
<td width="25%">5/1/2007</td>
<td width="25%">6/1/2007</td>
</tr>
<tr>
<td width="25%">C</td>
<td width="25%">In Progress</td>
<td width="25%">7/1/2007</td>
<td width="25%">12/1/2007</td>
</tr>
</table>
So now, the first question is a conditional formating question, (i looked
this up on google, but i found this mod (row??? command, could not get it to
work though) so column B is composed of drop down boxes with those 3 options.
Now, i would like it so when the closed option is chosen the entire row turns
grey aka, a certain format.
Secondly, It seems that we have a lot of projects that are similar to projects A
and B above. The duration period has ended yet they still show as open. How do I
program excel so it automatically changes the status of these projects to closed
and subsequently turns that row gray or whatever format?
Thank you for looking and helping me out!</p>
</body>
</html>
<body>
Hey guys,
I hope you can help me out with this
I have a spreadsheet that looks like the following:</p>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="25%">A</td>
<td width="25%">B</td>
<td width="25%">C</td>
<td width="25%">D</td>
</tr>
<tr>
<td width="25%">Project</td>
<td width="25%">Status</td>
<td width="25%">Start Date</td>
<td width="25%">End Date</td>
</tr>
<tr>
<td width="25%">A</td>
<td width="25%">Closed</td>
<td width="25%">4/1/2007</td>
<td width="25%">5.1/2007</td>
</tr>
<tr>
<td width="25%">B</td>
<td width="25%">Open</td>
<td width="25%">5/1/2007</td>
<td width="25%">6/1/2007</td>
</tr>
<tr>
<td width="25%">C</td>
<td width="25%">In Progress</td>
<td width="25%">7/1/2007</td>
<td width="25%">12/1/2007</td>
</tr>
</table>
So now, the first question is a conditional formating question, (i looked
this up on google, but i found this mod (row??? command, could not get it to
work though) so column B is composed of drop down boxes with those 3 options.
Now, i would like it so when the closed option is chosen the entire row turns
grey aka, a certain format.
Secondly, It seems that we have a lot of projects that are similar to projects A
and B above. The duration period has ended yet they still show as open. How do I
program excel so it automatically changes the status of these projects to closed
and subsequently turns that row gray or whatever format?
Thank you for looking and helping me out!</p>
</body>
</html>