RISKCONSULTANT
New Member
Hi,
I had a formula that was successful in the older versions on Excel that coloured every second row and made reading of separate long lines of data much better.
Since upgrading to excel 2007 worksheet, I cannot now find how I can enter the same formula.
the formula is... =mod9row(),2)<>0
i.e.
= Format when the condition is true (i.e. then colour row gray or green, or yellow etc)
For some unknown reason excel 2007 will not allow me to enter this old formula?
Any tips Guys?
Regards Clive
I had a formula that was successful in the older versions on Excel that coloured every second row and made reading of separate long lines of data much better.
Since upgrading to excel 2007 worksheet, I cannot now find how I can enter the same formula.
the formula is... =mod9row(),2)<>0
i.e.
= Format when the condition is true (i.e. then colour row gray or green, or yellow etc)
For some unknown reason excel 2007 will not allow me to enter this old formula?
Any tips Guys?
Regards Clive