Hi,

I am developing a data entry tool using excel i need some help on how to block some cells which is having cell background color.

example:

in sheet1 'A' column is having all the variables and '1' row is having scores, so the data entry person will enter the score for respective variable (they can enter only one score for one variable means there is a variable called 'maintenance of building'in cell 'A1' for this scores are Excellent, good, average, poor for each score we have given one column. So the data entry person can enter only one score in any of the above score in respective score column)like this after entering of scores for all variables in one section, end of this section in one cell we have given one formula to count the scores and this cell we have given some background color. once they enter the score for last variable in that section the cursor has to go next section directly instead of next cell which is having formula/which is having background color

I have attached one sample excel file in that wherever cell is having background color i dont want to move my cursor to that cell, the code has to search for empty cells means without any color

Thank u