Please Note ~ ensure you follow the steps on any playthrough where you are not going for the Usurpation Of Fire ending
Anri’s questline, if completed up to a certain point, will net you the Chameleon sorcery but only if you follow a strict set of steps, which are
From the Undead Settlement, Foot of the High Wall bonfire, head down the stairs, take a eft then near the end over to the right will be Yoel of Londor, speak with him and Accept His Service where he will travel to Firelink Shrine. Next you will need to Draw Out True Strength with Yoel which is done by dying 5 times, allowing him to give you 5 free levels. Once you have done so you then need to fast travel away to any area that isn’t in the Cemetery of Ash, such as the Undead Settlement, Foot of the High Wall bonfire then go back to Firelink Shrine where you will find Yoel dead and a new NPC, Yuria of Londor will be nearby. Speak with her to begin her questline
You then need to speak with Anri and Horace at the Road of Sacrifices, Halfway Fortress bonfire (they’re standing to the left of the bonfire) then after defeating the Crystal Sage in the Road of Sacrifices, head to Firelink Shrine and speak with them before defeating the Abyss Watchers
Make your way to the Catacombs of Carthus through to the rickety bridge you need to cross to fight High Lord Wolnir. Once across this bridge, hit it where it will fall creating a ladder, take it down and head out into Smouldering Lake. Stick to the right wall and go down the passageway to find Horace, either kill him or leave him, it’s your choice
After you have discovered Horace, go back to the rickety bridge and take the pathway up leading above the bridge, speak with Anri ensuring you DO NOT tell her where Horace is then continue through the game to the Irithyll of the Boreal Valley
When there, head to the Church of Yorshka bonfire and attack and kill the “statue” which is actually the Pilgrim of Londor in the left corner from when you enter the Church, you can then collect the Chameleon sorcery from the corpse