Hi,
As you want auto-coloring of your lookup cell without use of conditional formatting, I will provide the perfect solution for this. Please share your Excel sheet so that I can perform this task. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project.
Quality work with high accuracy and 100% customer satisfaction is guaranteed.
Thanks and regards,
Mohan