Feb 17 2020 01:36 PM
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!
Feb 17 2020 02:14 PM
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.
Feb 17 2020 02:28 PM
Thank you for your help, that worked!