Protect Rows for Certain Conditions in Two Columns

P

prkhan56

Hello All Experts,

I am using Office 2003 and have the following problem:

File name : AMC2005
Sheet Name : Combined
Current Range in Use A1:AB500 (and increasing day by day)

The sheet is designed having Headings in Row 1

My problem is that I wish to make to freeze the Row when certain
entries is made in two particular columns (viz A and B)

If the Value typed in Column A is 'Expired' AND Column B is typed
either (Paid, Invoice, or Check) then that entire row should be
protected (i.e. un-editable)

At present there is data in the current range A1:AB500 but when I fill
both Column A and Column B with the above condition then all rows which
meet the criteria should be frozen

Is this possible?

Thanks in advance


Rashid Khan
 
Top