Forum Discussion
Conditional Formatting a Table
Hello,
Answering your questions:
1) Based on your explanation, you have only one cell with a drop-down list for the names of the people. Logically, if you change that cell value (i.e. select another name for a new entry), all conditional formatting formulas will understand that and then change all accordingly. My suggestion is to include a drop-down for each row, and then assign a formula in accordance and in reference to that specific cell in the row. That is, for row 1 you have a drop-down list for a name entry, then you formulate your conditional formatting refering to that drop-down located in row 1. The same for row 2, 3, etc. Is that convenient for you? If that is not the case, you would be left to use VBA code for your desired functionality.
2) To prevent users entering manual values in a drop-down list you can go to Data tab, Data Validation, Error Alert and finally "Show error alert after invalid data is entered". If you want users to enter manually a number without a list, you can also go to Data Validation, Allow Whole Number and then set a minimum or a maximum (8).
3) It is difficult to know what is happening without having a sample document, for instance. But if you like my suggestion regarding point 1), you could use something like =A2="Dave". That would be all for your desired output. Conditional formatting will understand that if in cell A2 there is Dave, then you can fill with any color you like. Add additional conditions as desired with AND(), as you have already made.
Hope it helps.
Martin
Hello,
Answering your questions:
1) Based on your explanation, you have only one cell with a drop-down list for the names of the people. Logically, if you change that cell value (i.e. select another name for a new entry), all conditional formatting formulas will understand that and then change all accordingly. My suggestion is to include a drop-down for each row, and then assign a formula in accordance and in reference to that specific cell in the row. That is, for row 1 you have a drop-down list for a name entry, then you formulate your conditional formatting refering to that drop-down located in row 1. The same for row 2, 3, etc. Is that convenient for you? If that is not the case, you would be left to use VBA code for your desired functionality.
2) To prevent users entering manual values in a drop-down list you can go to Data tab, Data Validation, Error Alert and finally "Show error alert after invalid data is entered". If you want users to enter manually a number without a list, you can also go to Data Validation, Allow Whole Number and then set a minimum or a maximum (8).
3) It is difficult to know what is happening without having a sample document, for instance. But if you like my suggestion regarding point 1), you could use something like =A2="Dave". That would be all for your desired output. Conditional formatting will understand that if in cell A2 there is Dave, then you can fill with any color you like. Add additional conditions as desired with AND(), as you have already made.
Hope it helps.
Martin
