munkifisht
New Member
- Joined
- Mar 17, 2005
- Messages
- 39
I have a big sheet with lots of entries and I want to write some code that will change the format of a number of cells automatically when the value of a cell in that row changes. I have it working at the moment with conditional formatting, but that can only handle 3 conditions and I need to have an infinite number.
What I have at present is a list on the sheet which is used as a validation list for the values of row C. The options at present are Done, In Progress, To Do and On Hold, but I will need more in the future. Beside each entry in this list is a cell with a particular background colour, so in effect a key. What I would like to do is use a code that will look at the value of cell C whatever and depending on the value of that cell it will then apply the colour in the key to all relevent cells, and this will happen on all sheets through the entire workbook.I would also liek it to happen automatically and not through a macro. I also need the code to apply bold formatting to a row if the cell in B is filled. I should also say that each key may be different to each sheet.
What I have at present is a list on the sheet which is used as a validation list for the values of row C. The options at present are Done, In Progress, To Do and On Hold, but I will need more in the future. Beside each entry in this list is a cell with a particular background colour, so in effect a key. What I would like to do is use a code that will look at the value of cell C whatever and depending on the value of that cell it will then apply the colour in the key to all relevent cells, and this will happen on all sheets through the entire workbook.I would also liek it to happen automatically and not through a macro. I also need the code to apply bold formatting to a row if the cell in B is filled. I should also say that each key may be different to each sheet.