| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating
Hi there
I am created a file to keep track of marks. I want every other line to have the back ground fill in. Sometimes students names will be added or deleted. I don't want to have to change the format for each line when a student is added or deleted. Is there a way to do this? -- Thank-you! Ruth |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formating
CF/ Formula Is ...
=MOD(ROW(),2) -- David Biddulph "Ruth" wrote in message ... Hi there I am created a file to keep track of marks. I want every other line to have the back ground fill in. Sometimes students names will be added or deleted. I don't want to have to change the format for each line when a student is added or deleted. Is there a way to do this? -- Thank-you! Ruth |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formating
hi
you can use conditional formating to do that. it's called banding. see this site for detailed instructions. http://www.cpearson.com/excel/banding.htm Regards FSt1 "Ruth" wrote: Hi there I am created a file to keep track of marks. I want every other line to have the back ground fill in. Sometimes students names will be added or deleted. I don't want to have to change the format for each line when a student is added or deleted. Is there a way to do this? -- Thank-you! Ruth |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formating
Thank-you very much!
-- Thank-you! Ruth "FSt1" wrote: hi you can use conditional formating to do that. it's called banding. see this site for detailed instructions. http://www.cpearson.com/excel/banding.htm Regards FSt1 "Ruth" wrote: Hi there I am created a file to keep track of marks. I want every other line to have the back ground fill in. Sometimes students names will be added or deleted. I don't want to have to change the format for each line when a student is added or deleted. Is there a way to do this? -- Thank-you! Ruth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| Conditional Formating | Charts and Charting in Excel | |||
| Conditional Formating | Excel Worksheet Functions | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| In conditional formating, is it possible to do? | Excel Discussion (Misc queries) | |||
Linear Mode
