Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for change background according to data
i have excel 2007
i want to set up a rule or a setting or something so that when a cell gets a set of numbers it will change the color of the cell to green example in the cell i want to add 5, 15, 25, 30 etc and any time a 5 or a 15 or a 25 or a 30 is typed into that cell it will chance the cell to green. is there any way of doing this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for change background according to data
assuming cell A2
Go to Format-Conditional Format Cell formula is: =OR(A2=5,A2=15,A2=25,A2=30) Then go to format and set pattern to whatever color you want. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "shallowz" wrote: i have excel 2007 i want to set up a rule or a setting or something so that when a cell gets a set of numbers it will change the color of the cell to green example in the cell i want to add 5, 15, 25, 30 etc and any time a 5 or a 15 or a 25 or a 30 is typed into that cell it will chance the cell to green. is there any way of doing this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for change background according to data
that worked thank you very much
now i have another question what if i want to use the same number but i want to place them in multiple rows like row 18-24? "Luke M" wrote: assuming cell A2 Go to Format-Conditional Format Cell formula is: =OR(A2=5,A2=15,A2=25,A2=30) Then go to format and set pattern to whatever color you want. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "shallowz" wrote: i have excel 2007 i want to set up a rule or a setting or something so that when a cell gets a set of numbers it will change the color of the cell to green example in the cell i want to add 5, 15, 25, 30 etc and any time a 5 or a 15 or a 25 or a 30 is typed into that cell it will chance the cell to green. is there any way of doing this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for change background according to data
Copy the cell that has the conditional format, select the area/rows you want
the formatting applied. Right-click, special paste, format only. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "shallowz" wrote: that worked thank you very much now i have another question what if i want to use the same number but i want to place them in multiple rows like row 18-24? "Luke M" wrote: assuming cell A2 Go to Format-Conditional Format Cell formula is: =OR(A2=5,A2=15,A2=25,A2=30) Then go to format and set pattern to whatever color you want. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "shallowz" wrote: i have excel 2007 i want to set up a rule or a setting or something so that when a cell gets a set of numbers it will change the color of the cell to green example in the cell i want to add 5, 15, 25, 30 etc and any time a 5 or a 15 or a 25 or a 30 is typed into that cell it will chance the cell to green. is there any way of doing this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for change background according to data
PERFECT
thank you "Luke M" wrote: Copy the cell that has the conditional format, select the area/rows you want the formatting applied. Right-click, special paste, format only. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "shallowz" wrote: that worked thank you very much now i have another question what if i want to use the same number but i want to place them in multiple rows like row 18-24? "Luke M" wrote: assuming cell A2 Go to Format-Conditional Format Cell formula is: =OR(A2=5,A2=15,A2=25,A2=30) Then go to format and set pattern to whatever color you want. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "shallowz" wrote: i have excel 2007 i want to set up a rule or a setting or something so that when a cell gets a set of numbers it will change the color of the cell to green example in the cell i want to add 5, 15, 25, 30 etc and any time a 5 or a 15 or a 25 or a 30 is typed into that cell it will chance the cell to green. is there any way of doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I universally change the background of a data label in grap | Charts and Charting in Excel | |||
Auto change background of color based on formula | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) |