| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
