Excel Formula Question

[BigErn1175]

Hi, I was hoping someone can help me with an excel formula. I have a drop down list in column E with 5 different values. I would like each value to have a corresponding affect on the status of the cells in column A. For instance, if the value in the drop down for E6 is Complete, I would like the value in A6 to turn Green and be crossed out.

Thank you for your help!

[#2]

@BigErn1175 

You may apply conditional formatting rule with formula like

=$E6="Completed"

to highlight A6. To apply the cross that perhaps by VBA programming, but that could be workaround as a pattern applied.

[#3]

@Sergei Baklan 

Thank you for your help, that worked!

[#4]

@BigErn1175 , glad to help