I have a i have a range of cells (B7:Z14) numbered 1-200 that will
correspond to the number of jobs given to an employee to complete and i have
a cell that the number of jobs can be typed into and when i type that number
for example the number 35, cells 1-35 in that range will automatically will
have a green background and white lettering, and if the number is lower than
two hundred it will format the rest of the cells within that range with a
black background and white lettering and if selected again after the original
formatting, the format will change to a red background and white lettering,
amnd if it is selected by mistake after the first formating is there a way
to selected it and change it back to a green backgound and white lettering or
is ther a better approach to this.