ExcelBanter - Lock cell formats (conditional format)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lock cell formats (conditional format) (https://www.excelbanter.com/excel-worksheet-functions/172133-lock-cell-formats-conditional-format.html)

Saintsman

Lock cell formats (conditional format)

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

ryguy7272

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?

All times are GMT +1. The time now is 07:02 PM.