Forum Discussion
Solved
Consecutive drop down menu
I am trying to set up an administration in Excel. In the sheet account in column C I want to fill in categories of income and expense. In column D of the sheet account I want to specify column C. But...
Dutch no problem 🙂
See attached workbook. It uses Named Ranges and INDIRECT in the conditional formatting for the Description dropdown. For INDIRECT to work I changed the Category "Fixed Charges" to "Fixed_Charges" (i.e. with the underscore replacing the space.
@Riny_van_Eekelen, Thanks again and figured it out. Drop down menu's are working perfect now. I also use excel for Mac so screens looks the same ;-))