I am trying to use conditional formatting in Excel to create a formula (if statement) that will hide any row in Column A whose drop down has a value of complete.
I tried several variations of
IF Range(A3).value="Complete" Then Range(A3).EntireRow.Hidden = TRUE
This does not work for me.
Please help and thank you for helping.
New contributor
TomC. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.