Column V: =Countif(G7, “>$0”) Column W: Data Validation list with 8 options
I want Column W to populate the first option from the list “Opportunity” IF the prior cell is greater than zero. .... (pls see attached picture if you can as my symbols appear to adjust above once I post this message)
Just for reference, I am only “okay” at Excel so please give me laymen’s instructions if you can 😬 ty for your help!!