Kylie Thomas
asked on
Automate a cell
Hello i have a sheet and i want to have a column that says if it is approved or not but if i click approved, i want all the other options to all automatically say unapproved. Is there a formula for this? I tried doing and IF formula but it kept coming back to me saying this is circular.
You mean like attached?
If you select Approved in B1 all range in B2 to whatever range will be UnApproved and vise versa.
Kylie_Approved-UnApproved.xlsx
If you select Approved in B1 all range in B2 to whatever range will be UnApproved and vise versa.
Kylie_Approved-UnApproved.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is exactly what i need thank you! Thanks for you help!
You're Welcome Kylie! Glad I was able to help
For that, you will need VBA.