Hi,
I have 10 sheet for inventory record of Paintings, Silver Jewllery,
Textiles, Wooden Items etc. I track cost price of entering its ID number by
using this this formula
=IF(A523="","",VLOOKUP(A523,INDIRECT(B523),10,0)*( 1-(50%*--(B523<"slvrJwllry_Articles")))) to track specific value from respecive sheet.

But I want to do more. Is there any way when I enter a IDnumber of
particular item, then in the respective sheet this item number's detail
automatically freeze and change its color.