View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JBeaucaire[_47_] JBeaucaire[_47_] is offline
external usenet poster
 
Posts: 1
Default Copy Conditional Formats on a List


Use the FORMAT PAINTER icon (paint brush) to paint the format settings
from the last entry in your current list into the * row, the expansion
row that appears when your cursor is in the List somewhere.

Then exit the list, then reenter the list and add a new row using the *
row. Should work from then on.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46803