User Profile
airoosh
Copper Contributor
Joined 6 months ago
User Widgets
Recent Discussions
Auto highlight cell
Hello, I need help in creating a formula (through conditional formatting maybe?) where, when a name/names are selected in the dropdown - those names in column E (source of the dropdown list data) will be highlighted/formatted. The goal: So user can know not to chose that name again as it is taken...298Views0likes1CommentHelp on formula
I have two sheets. TheCoordinatorsheet is like a master file and cell B7 to CM26 has a conditional formatting that I want to populate on theConsultantsheet. Coordinator sheet - master file If say on the Consultant sheet - coordinator C1 is selected, I want the 'V with green fill' be populated on the matching dates: FYI - column A in Consultant sheet is a dropdown of the list of coordinators in the Coordinator Sheet I use this formula but its giving me the #N/A error: =INDEX(Coordinators!$B$7:$CM$26,MATCH(Consultant!B11,Coordinators!$B$6:$CM$6,0),MATCH(Consultant!$A$12,Coordinators!$A$7:$A$26,0)) You're assistance is greatly appreciated!260Views0likes1Comment
Recent Blog Articles
No content to show