cell highlighting depending on listed items
- Thread starter Tobby
- Start date
Mike H..
Active Member
Have a look at your workbook
Mike H..
Active Member
Hi,
I don't understand. I set up conditional formatting to shade the cells if any of the letters appear in the range G10:G16. Where do we look to decide whether to shade the cells?
NARAYANK991
Excel Ninja
Hi Tobby ,
The problem here is the layout of the workbook itself ; everything has been put in one worksheet ; for a stranger to figure out what is what is a difficult exercise.
Can you put input data in a separate tab , on its own ?
Put the configuration / master data in a separate tab ; put the desired output tables in a separate tab.
Once this is done , describe the logic that is needed to process the input data and arrive at the output.
Secondly , when ever you give an example , please select an example which clearly illustrates your requirement ; for instance , you have chosen the two endpoints Hamburg and Munich , which makes it easy to assume different explanations ; if you can choose any of the in-between stations , such as :
Hanover - Berlin
Hanover - Leipzig
Hanover - Nuremberg
Berlin - Leipzig
Berlin - Nuremberg
Leipzig - Nuremberg
it would make it easier to understand.
As far as I can see , you have 3 inputs , through the DV dropdowns in C3 , E3 and G3 ; you also have the output table shown.
The requirement is that the cells in the output table should be colored if , for the selected input date and stations , there are seats available.
For this purpose , are we supposed to make use of the data given in the range F10 : I16 ? Will this data be the same for every date ?
Are we supposed to make use of the data in A11 : B17 ? If not , please remove this from its present position , and put it in some remote corner , away from the user.
As I see it , if the 2 stations selected are Hamburg and Munich , then the routes are as follows :
1. Hamburg - Berlin , Berlin - Nuremberg , Nuremberg - Munich
2. Hamburg - Berlin , Berlin - Munich
3. Hamburg - Leipzig , Leipzig - Nuremberg , Nuremberg - Munich
Thus the cells to be shaded in the output table are :
1. C , A , H
2. C , K
3. I , J , H
which means overall , cells A , C , H , I , J and K should be shaded.
Can you explain how D can be shaded ?
Narayan
The problem here is the layout of the workbook itself ; everything has been put in one worksheet ; for a stranger to figure out what is what is a difficult exercise.
Can you put input data in a separate tab , on its own ?
Put the configuration / master data in a separate tab ; put the desired output tables in a separate tab.
Once this is done , describe the logic that is needed to process the input data and arrive at the output.
Secondly , when ever you give an example , please select an example which clearly illustrates your requirement ; for instance , you have chosen the two endpoints Hamburg and Munich , which makes it easy to assume different explanations ; if you can choose any of the in-between stations , such as :
Hanover - Berlin
Hanover - Leipzig
Hanover - Nuremberg
Berlin - Leipzig
Berlin - Nuremberg
Leipzig - Nuremberg
it would make it easier to understand.
As far as I can see , you have 3 inputs , through the DV dropdowns in C3 , E3 and G3 ; you also have the output table shown.
The requirement is that the cells in the output table should be colored if , for the selected input date and stations , there are seats available.
For this purpose , are we supposed to make use of the data given in the range F10 : I16 ? Will this data be the same for every date ?
Are we supposed to make use of the data in A11 : B17 ? If not , please remove this from its present position , and put it in some remote corner , away from the user.
As I see it , if the 2 stations selected are Hamburg and Munich , then the routes are as follows :
1. Hamburg - Berlin , Berlin - Nuremberg , Nuremberg - Munich
2. Hamburg - Berlin , Berlin - Munich
3. Hamburg - Leipzig , Leipzig - Nuremberg , Nuremberg - Munich
Thus the cells to be shaded in the output table are :
1. C , A , H
2. C , K
3. I , J , H
which means overall , cells A , C , H , I , J and K should be shaded.
Can you explain how D can be shaded ?
Narayan