Dear Sir,
I have two sheets; one is tally and another one is tally1.
Tally is colored and tally1 is non colored.
I wanted to apply formula or solution to give same color for the same item is available in tally1.
For example: tally sheet has 09-08-2019 Receipt 311784 20800.00 which is colored orange.
And tally1 has also same item available so I have colored manually.
Please advise solution as I have 12 months data which needs to be colored but manual is difficult.
I have two sheets; one is tally and another one is tally1.
Tally is colored and tally1 is non colored.
I wanted to apply formula or solution to give same color for the same item is available in tally1.
For example: tally sheet has 09-08-2019 Receipt 311784 20800.00 which is colored orange.
And tally1 has also same item available so I have colored manually.
Please advise solution as I have 12 months data which needs to be colored but manual is difficult.