poleary2000
Active Member
- Joined
- Apr 1, 2002
- Messages
- 354
Good afternoon,
I have two sheets. One with many inputs, and one with a listing of unique inputs. The unique inputs, I have formatted the way I want to look on the other sheet. Is there a way to conditionally format the inputs page with the formate on the unique inputs page based on what is entered into a cell?
I know I can do this with Conditional Formatting, but I don't want to create 30 rules. I want to create one rule that checks for the value in the list and if found, applies the format found in that cell. Is that possible without VBA? If so, great. If not, could you help with code that changes based on the cell value?
I have two sheets. One with many inputs, and one with a listing of unique inputs. The unique inputs, I have formatted the way I want to look on the other sheet. Is there a way to conditionally format the inputs page with the formate on the unique inputs page based on what is entered into a cell?
I know I can do this with Conditional Formatting, but I don't want to create 30 rules. I want to create one rule that checks for the value in the list and if found, applies the format found in that cell. Is that possible without VBA? If so, great. If not, could you help with code that changes based on the cell value?