how to Conditional format a cell with a drop down list with a different text value depending on another cell which has a date entered.
<tbody>
</tbody>
If A1:Z1 uses a drop down list containing multiple items ie. review, checked, completed and B1 has a date which is manually entered when completed, can A1 be formatted to then show the word 'closed'?
A | B | |
1 | ||
2 |
<tbody>
</tbody>
If A1:Z1 uses a drop down list containing multiple items ie. review, checked, completed and B1 has a date which is manually entered when completed, can A1 be formatted to then show the word 'closed'?