I am producing quite a lengthy excel report. To aid in pleasant viewing, I would like to alternate background-colorss for the rows.
could someone help me out with the syntax for working out if a number is a whole number or not? i want to do it so that if the row number divided by 2 is a whole number, use one colour, otherwise use another.
secondly, this is a basic question - i am only a newbie at vba... how do I use RGB colours for a row? Is that possible? or do you have to stick with excels choice?
Visit my site: http://www.drybonesuk.com