sticksandtriangles
Structural
- Apr 7, 2015
- 493
I am an excel beginner and wanted to know if it was possible to conditional format cells based on a drop down list.
For example, I have an input form that looks like this with drop down activities:
I have another sheet that has sample data formats like this (each cell has a specific custom formatted data assigned to it):
Ideally I want to conditionally format my cells to that if "walking" is selected in the 1st sheet, the data input is formatted based on the sample data format of the 2nd sheet.
Hopefully that makes sense. I played around with conditional formatting, but it seems like I need my format button to be able to be programmable with a vlookup type function.
In the end, I am going to have a whole bunch of activities in the list and I really want the input form to be dynamic based on the sample data format of the 2nd sheet.
Thanks!
S&T
For example, I have an input form that looks like this with drop down activities:

I have another sheet that has sample data formats like this (each cell has a specific custom formatted data assigned to it):

Ideally I want to conditionally format my cells to that if "walking" is selected in the 1st sheet, the data input is formatted based on the sample data format of the 2nd sheet.

Hopefully that makes sense. I played around with conditional formatting, but it seems like I need my format button to be able to be programmable with a vlookup type function.

In the end, I am going to have a whole bunch of activities in the list and I really want the input form to be dynamic based on the sample data format of the 2nd sheet.
Thanks!
S&T