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:
>
> 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.
>
|
Similar Threads
