can i format a group of cells based on the number entered in a cel

[mikeinohio]

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.

 

[Stefi]

If cell for number of jobs is A1 then select range B7:Z14 and apply
conditional formatting with these formulae
1st condition (white on green)
=OR(ROW()-6<=INT($A$1/25),AND(ROW()-6=INT($A$1/25)+1,COLUMN()-1<=MOD($A$1,25)))
2nd condition (white on black)
=NOT(OR(ROW()-6<=INT($A$1/25),AND(ROW()-6=INT($A$1/25)+1,COLUMN()-1<=MOD($A$1,25))))

But I didn't understand the second part of your request:
"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"

Please try to clarify it!

Regards,
Stefi



„mikeinohio†ezt írta: