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.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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'?
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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'?