Any help is really appreciated.
What I want to know is how to apply a conditional formatting on multiple cells(from multiple sheets) based on a drop down from Sheet1.
Let me attach my file.
For example when I selected the "grade" which is grade 1 it should automatically highlight the advanced, intermediate and superior. I was able
to do that in the first sheet. My issue is that I need to do this in 100 Sheets and doing it manually can take forever. Is there any way for a much faster approach?