View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Lock cell formats (conditional format)

Click Data Validation. Choose the appropriate option for your needs.


Regards,
Ryan--


--
RyGuy


"Saintsman" wrote:

Is it possible to lock a cells format so that you can only ever paste values
into that cell?