Reply to thread

Message: [QUOTE="Gazz_85, post: 3234708"] not to sure this help really. what i have is a list of 8 cells (representing work areas) each cell has a current job identified by unit # when work is ongoing i want the cells to have defualt formatting. once a job is complete i need it to display the unit# with a green background format so the workers will knoe that the job is complete and the unit can be moved (can take a while to move). once the unit has been moved the unit number is deleted from that cell (work area) and the format returns to default. allowing that work area to be used for another job. the problem i have is i can set a defualt format, can change it the green when job complete and can set a condition for the cell to revert to defualt settings once deleted. then the problem is when the next unit# is inputted the format automatically is set to green. the way i did it was to set defiualt format, to change it to green using a recorded macro assigned to a command button, and revert it back to default on the condition that the cell value was less then 1.(all unit# are 6 digits between 300000 - 500000). any other ideas??? [/QUOTE]