Hi.. am Elango. I have a doubt in excel as below
I have a Excel with 10 sheets with different data's at Revision 0. Now i have created a summery sheet with "indirect" formula.
Now i need to revise few data's of the sheets and mark as Red fill color( to identify it is revision 1). The values get updated in the summery sheet automatically. But i also need the red color to be automatically updated in summery sheet. Is there any way possible ?