Avatar of vegas86

asked on 

Macro to lock and highlight row based on cell value


I have a spreadsheet with data in columns A:AD and I would like for a macro to lock and highlight this range bright pink once "Paid" is selected from the dropdown list in column AD.

Does anyone know how I would go about this?
I know it is simple but I haven't found any solutions on google yet.
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon