I have data in two columns (N and O) on my worksheet. Column N is setup with conditional formatting to change the cell color based on the value in the cell. The three options for column N are Not Started, Work in Progress, and Completed. These are setup as a Data Validation List.
<style type="text/css">
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</style>
<table class="tableizer-table">
<tr class="tableizer-firstrow"><th>Site Status</th><th>% Complete</th></tr> <tr><td>Not Started</td><td>6%</td></tr> <tr><td>In Progress</td><td>4%</td></tr> <tr><td>Complete</td><td>100%</td></tr></table>
I want to automate the selection of the value in Column N if the value in Column O is greater than 0%.
For example, if cell 06 = 1% thru 99%, it will populate Work in Progress in cell N6. If cell 06 = 100% it will populate Completed in Cell N6.
The main thing I do not want to do is change the conditional formatting for the colors or the data validation values.
Is another conditional format the way to go about this?
Thanks,
Tom
<style type="text/css">
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</style>
<table class="tableizer-table">
<tr class="tableizer-firstrow"><th>Site Status</th><th>% Complete</th></tr> <tr><td>Not Started</td><td>6%</td></tr> <tr><td>In Progress</td><td>4%</td></tr> <tr><td>Complete</td><td>100%</td></tr></table>
I want to automate the selection of the value in Column N if the value in Column O is greater than 0%.
For example, if cell 06 = 1% thru 99%, it will populate Work in Progress in cell N6. If cell 06 = 100% it will populate Completed in Cell N6.
The main thing I do not want to do is change the conditional formatting for the colors or the data validation values.
Is another conditional format the way to go about this?
Thanks,
Tom