I have a table im trying to do two things in. I am intending the user to enter parameters into the following cells
Q32 - selects rank
Q33 - user enters a date
From that I need the following to happen:
1. Enter into cell Q35, the year of the next applicable board
2. highlight the row in the appropriate table
There are three tables, one for each rank possibility and each table list the year of the next board based on a date range. The users date range entered in Q33 should fall between two dates in the corresponding table.
I have attempted to conditionally format using the OR function but cant get the intersection to work and correctly highlight the appropriate cell.
I havent been able to figure out how to retrieve the appropriate year into the cell either.
The tables are copy and pasted from an external source and are updated each year. We have no control over the formatting, we just have to work with what we get.
<tbody>
</tbody>https://drive.google.com/open?id=1m5fPg73rfk9oWAOKsYWM5pGSsDxmzgD6
Q32 - selects rank
Q33 - user enters a date
From that I need the following to happen:
1. Enter into cell Q35, the year of the next applicable board
2. highlight the row in the appropriate table
There are three tables, one for each rank possibility and each table list the year of the next board based on a date range. The users date range entered in Q33 should fall between two dates in the corresponding table.
I have attempted to conditionally format using the OR function but cant get the intersection to work and correctly highlight the appropriate cell.
I havent been able to figure out how to retrieve the appropriate year into the cell either.
The tables are copy and pasted from an external source and are updated each year. We have no control over the formatting, we just have to work with what we get.
The following is how the the tables are organized and the date range comes to us as a single field. There are 1 or 3 columns associated with each possible rank.
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
I have the file here below. If someone can help me out and steer me in the right direction id be very greatfull! |
<tbody>
</tbody>