Re: Index match function to enter / color cells
Hi Rakesh,
I am glad that the solution worked for you.
Personally I avoid VBA if there is a standard Excel function which will do the job.
If you wanted to do it using VBA you would need to run through each cell and evaluate it against your condition based on an IF statement.
So you would evaluate the cell to see if it meets the set condition, if it does then you would apply a specific format to the cell, if not you would move on to the next cell to evaluate.
Regards,
Myles