Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
127
Views
Topic starter
I'm not sure how to approach this one. If index match is the correct choice.
When cells in columns AP:AT are highlighted (colored), then enter "Y" in the appropriate cells in Columns AW:BA.
Start row 15.
Posted : 06/06/2019 5:14 pm
Hello,
With this approach you need a VBA solution. Coloured cells is nothing you can check for and use as values/conditions in formulas. You find more info here in how to write a macro and check the cell colours.
If you don’t want to use VBA then you need to change the approach and use number or text values as a trigger.
Posted : 06/06/2019 10:19 pm
