Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can i format a group of cells based on the number entered in a cel
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can i format a group of cells based on the number entered in a cel
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop based on number entered in userform | Excel Worksheet Functions | |||
Need to set up a number based on date entered | Excel Discussion (Misc queries) | |||
Autoformat/Conditional Format of entered Number | Excel Discussion (Misc queries) | |||
Format cell so number entered will show only one way | Excel Worksheet Functions | |||
Changing chart color based on number entered | Charts and Charting in Excel |