Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting odd/even rows
Hi All,
I know there are solutions to colouring odd & even rows, but could someone tell me why what i'm trying is not working (and if there is a way of making it work)... in conditional formatting for some cells in a column, i used conditional formatting as follows: - [Formula is] "=iseven(rows())"... and if that condition is true, change the cell colour ie, if the row for that cell is even, the 'iseven' result is true and therefore it should carry out the conditional formatting. what actually happens is an error, telling me i can't refer to other worksheets/books, btu i didn't think i was doing that anyway!! i'm missing something obvious here, but i've tried several variations on this theme but still can't do it. thanks fo any guidance, Tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting odd/even rows
Hi
first: use ROW() and not ROWS(). Try the following (as it does not require the Analysis toolpak addin): =MOD(ROW(),2)=0 -- Regards Frank Kabel Frankfurt, Germany "Tim" schrieb im Newsbeitrag ... Hi All, I know there are solutions to colouring odd & even rows, but could someone tell me why what i'm trying is not working (and if there is a way of making it work)... in conditional formatting for some cells in a column, i used conditional formatting as follows: - [Formula is] "=iseven(rows())"... and if that condition is true, change the cell colour ie, if the row for that cell is even, the 'iseven' result is true and therefore it should carry out the conditional formatting. what actually happens is an error, telling me i can't refer to other worksheets/books, btu i didn't think i was doing that anyway!! i'm missing something obvious here, but i've tried several variations on this theme but still can't do it. thanks fo any guidance, Tim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting odd/even rows
Frank
thanks - a quick and simple solution (i feel a bit stupid for not working that one out) cheers tim "Frank Kabel" wrote in message ... Hi first: use ROW() and not ROWS(). Try the following (as it does not require the Analysis toolpak addin): =MOD(ROW(),2)=0 -- Regards Frank Kabel Frankfurt, Germany "Tim" schrieb im Newsbeitrag ... Hi All, I know there are solutions to colouring odd & even rows, but could someone tell me why what i'm trying is not working (and if there is a way of making it work)... in conditional formatting for some cells in a column, i used conditional formatting as follows: - [Formula is] "=iseven(rows())"... and if that condition is true, change the cell colour ie, if the row for that cell is even, the 'iseven' result is true and therefore it should carry out the conditional formatting. what actually happens is an error, telling me i can't refer to other worksheets/books, btu i didn't think i was doing that anyway!! i'm missing something obvious here, but i've tried several variations on this theme but still can't do it. thanks fo any guidance, Tim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting odd/even rows
Hi Tim,
it is ROW() not rows() =ISEVEN(ROW()) =ISODD(ROW()) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tim" wrote in message ... Hi All, I know there are solutions to colouring odd & even rows, but could someone tell me why what i'm trying is not working (and if there is a way of making it work)... in conditional formatting for some cells in a column, i used conditional formatting as follows: - [Formula is] "=iseven(rows())"... and if that condition is true, change the cell colour ie, if the row for that cell is even, the 'iseven' result is true and therefore it should carry out the conditional formatting. what actually happens is an error, telling me i can't refer to other worksheets/books, btu i didn't think i was doing that anyway!! i'm missing something obvious here, but i've tried several variations on this theme but still can't do it. thanks fo any guidance, Tim |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting odd/even rows
sorry about that didn't look first, was already answered and better by Frank
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting odd/even rows
Rows() was a typo on my part - sorry, i knew it should've been row(), but it
still didn't work thanks anyway though - Franks reply worked like a dream! "David McRitchie" wrote in message ... sorry about that didn't look first, was already answered and better by Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting across rows | Excel Worksheet Functions | |||
Conditional formatting for rows | Excel Worksheet Functions | |||
Conditional Formatting of rows | Excel Discussion (Misc queries) | |||
Conditional Formatting of Rows | Excel Discussion (Misc queries) | |||
How to get more than 3 rows in Conditional Formatting | Excel Discussion (Misc queries) |