| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell shading
the formula to shade every other cell in a spreadsheet doesn't work for me.
i select the worksheet and type in the following formula, but nothing happens. any suggestions? =MOD(ROW(),2)=0 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell shading
See 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) "GUH" wrote in message ... the formula to shade every other cell in a spreadsheet doesn't work for me. i select the worksheet and type in the following formula, but nothing happens. any suggestions? =MOD(ROW(),2)=0 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell shading
Sorry should be
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) "GUH" wrote in message ... the formula to shade every other cell in a spreadsheet doesn't work for me. i select the worksheet and type in the following formula, but nothing happens. any suggestions? =MOD(ROW(),2)=0 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell shading
Will shade every other ROW
-- Gary''s Student - gsnu200738 "GUH" wrote: the formula to shade every other cell in a spreadsheet doesn't work for me. i select the worksheet and type in the following formula, but nothing happens. any suggestions? =MOD(ROW(),2)=0 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell shading
The formula has to go into the Formula Is: dialog in FormatConditional
Formatting. Sounds like you just entered it in a cell. Gord Dibben MS Excel MVP On Mon, 20 Aug 2007 07:26:03 -0700, GUH wrote: the formula to shade every other cell in a spreadsheet doesn't work for me. i select the worksheet and type in the following formula, but nothing happens. any suggestions? =MOD(ROW(),2)=0 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to sort the data by cell shading or cell color? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Cell Shading | Excel Discussion (Misc queries) | |||
| shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
