Conditional format a cell with a drop down value with a different text based on another cell date value

Mr Dean

New Member
Joined
Jun 28, 2019
Messages
1
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.

AB
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'?
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,692
Conditional formatting doesn't change values in the cells its applied to, only the format of those cells.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,411
Messages
5,414,253
Members
403,522
Latest member
Abel_excel

This Week's Hot Topics

Top