| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
colour rows alternating colour
Hi there,
I'd like to create a conditional formatting formula to colour my rows yellow and white. Is this possible? Any help greatly appreciated Thanks Suzanne |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
colour rows alternating colour
Highlight the range where you want this to happen and select Format--
Conditional Formatting. Select Formula Is from the drop down and place one of the the formulas below in the field. Make your necessary formatting changes. This will format all of the even rows: =MOD(ROW(),2)=0 This will format all of the odd rows: =MOD(ROW(),2) Grd wrote: Hi there, I'd like to create a conditional formatting formula to colour my rows yellow and white. Is this possible? Any help greatly appreciated Thanks Suzanne |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
colour rows alternating colour
Pick a cell and conditional format:
Formula Is: =MOD(ROW(),2)=1 and pick yellow Then copy the cell and paste/special/formats over the cells of interest. -- Gary''s Student - gsnu200755 "Grd" wrote: Hi there, I'd like to create a conditional formatting formula to colour my rows yellow and white. Is this possible? Any help greatly appreciated Thanks Suzanne |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
colour rows alternating colour
http://www.xldynamic.com/source/xld.CF.html#rows
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Grd" wrote in message ... Hi there, I'd like to create a conditional formatting formula to colour my rows yellow and white. Is this possible? Any help greatly appreciated Thanks Suzanne |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
colour rows alternating colour
wow
tx s "Bob Phillips" wrote: http://www.xldynamic.com/source/xld.CF.html#rows -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Grd" wrote in message ... Hi there, I'd like to create a conditional formatting formula to colour my rows yellow and white. Is this possible? Any help greatly appreciated Thanks Suzanne |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
colour rows alternating colour
works great
Tx "Gary''s Student" wrote: Pick a cell and conditional format: Formula Is: =MOD(ROW(),2)=1 and pick yellow Then copy the cell and paste/special/formats over the cells of interest. -- Gary''s Student - gsnu200755 "Grd" wrote: Hi there, I'd like to create a conditional formatting formula to colour my rows yellow and white. Is this possible? Any help greatly appreciated Thanks Suzanne |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
colour rows alternating colour
works thanks
"JW" wrote: Highlight the range where you want this to happen and select Format-- Conditional Formatting. Select Formula Is from the drop down and place one of the the formulas below in the field. Make your necessary formatting changes. This will format all of the even rows: =MOD(ROW(),2)=0 This will format all of the odd rows: =MOD(ROW(),2) Grd wrote: Hi there, I'd like to create a conditional formatting formula to colour my rows yellow and white. Is this possible? Any help greatly appreciated Thanks Suzanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternating row colour according to month | Excel Discussion (Misc queries) | |||
| How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| alternating cell colour | New Users to Excel | |||
| Text in Blue colour, but print in black colour | Excel Worksheet Functions | |||
Linear Mode
