View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Highlight every other row

"Bri" wrote:
I have a large list of over 3 thousand rows that will be printed. Does
anyone know of a way to have Excel highlight every other row to make it
easier to read across, so I dont have to do it manually?


One play ..

Select A1, then press CTRL+A to select the entire sheet
Click Format Conditional Formatting
Condition 1, Formula is: =MOD(ROW(),2)
Click Format button Patterns tab Light green? OK
Click OK at the main dialog

The above will yield alternating light green rows
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---