Highlighting cell according to tab

[Tom22]

Hi All,

Hope every one keeping safe!!

I have to working on one file, which has number of tabs and large amount of data.

All these tabs data comes in summary tab via formulas.

I need to analyze this summary tab.....I need to manually see from which tab this is coming from, which is very lengthy task.

So I am looking a way from I can find out automatically, like cells get themselves highlighted in colors and each color denotes one tab.

It will make life easy, because by looking at cell I can find out which tab it is referring to.

or any other suggestions are welcome.

Attaching one test file for reference.

thanks in advance

 

[bosco_yip]

Try,

1] Change your tab name from "Sheet2", "Sheet3" and "Sheet4" into "Amount", "Dept" and "Tax"

Then,

2] In C5 formula copied across and down :

=VLOOKUP($B5,INDIRECT(C$4&"!B1:C100"),2,0)

 

[Tom22]

Try,

1] Change your tab name from "Sheet2", "Sheet3" and "Sheet4" into "Amount", "Dept" and "Tax"

Then,

2] In C5 formula copied across and down :

=VLOOKUP($B5,INDIRECT(C$4&"!B1:C100"),2,0)

View attachment 74982

Thanks Bosco, but it doesn't solve the problem.....if you see everything is highlight with same color....how do we get to know 1510 number coming from which tab without selecting this particular cell.

 

[vletm]

Tom22
All Amounts seems to come from Sheet2
All Dept seems to come from Sheet3
All Tax seems to come from Sheet4
Do You have some kind of other expected result?
If so, then please do it eg manually.

 

[Tom22]

Tom22
All Amounts seems to come from Sheet2
All Dept seems to come from Sheet3
All Tax seems to come from Sheet4
Do You have some kind of other expected result?
If so, then please do it eg manually.

Sure......data can come from any of the tab...I have made some changes so now we can see Amount, tax and dept coming from different tabs.
Data is huge hence just want to see one particular cell and want to know with color code or something...attaching one more excel

 

[vletm]

Tom22
Are You sure that Your sample is as Your real file?
If eg Your 1510 can find in more than one sheet or none - what to do?
How to guess that eg Sheet2's E-column values are ... Names or Depts (both has text)?
... and what would be F-column values? ... Numbers seems to be Amounts or Taxes.