ozibryan
01-05-2006, 03:40 AM
I am using excel rows to capture data records, I would like to selectively format the 'current' or 'last' row ( next record) based on a selected value.
An example is where
I use a drop box to select product "a" and based on this selection I'd need to make cells (cols) 1, 3 & 7 'blue' and cells (cols) 2 4 5 & 6 are set to read only - for example.
Next line, for example I select 'product "b" for example whereupon I want to have cells (cols)1, 3 & 7 'protected' and I color (cols) 2, 4 5 & 6.
Hope this makes sense, I have been able to code bits and pieces, however I am an 'excel newbie' and would greatly appreciate some help pulling this together.
Any help would be very much appreciated
An example is where
I use a drop box to select product "a" and based on this selection I'd need to make cells (cols) 1, 3 & 7 'blue' and cells (cols) 2 4 5 & 6 are set to read only - for example.
Next line, for example I select 'product "b" for example whereupon I want to have cells (cols)1, 3 & 7 'protected' and I color (cols) 2, 4 5 & 6.
Hope this makes sense, I have been able to code bits and pieces, however I am an 'excel newbie' and would greatly appreciate some help pulling this together.
Any help would be very much appreciated