T
Texins Karate
I am running Excel 2003 with a spreadsheet that has Activity in column A,
Status (Open or Closed) in column B, Days of Week (Sun thru Sat) in columns C
thru I. I am looking for a way to "lock" columns C thru I if column B is
"Closed" for each row of Activity in Column A
example:
Col A Col B Col C Col D Col E Col F
Activity 1 Closed lock lock lock lock
Activity 2 Open unlock unlock unlock unlock
Status (Open or Closed) in column B, Days of Week (Sun thru Sat) in columns C
thru I. I am looking for a way to "lock" columns C thru I if column B is
"Closed" for each row of Activity in Column A
example:
Col A Col B Col C Col D Col E Col F
Activity 1 Closed lock lock lock lock
Activity 2 Open unlock unlock unlock unlock