Hello! I am a teacher doing some data sheets for the upcoming school year. I am mainly self-taught and google solutions often, but can't get this to work. (I'm actually in Google Sheets so that admin can get live updates)
Two different things, but wanting the same result:
1. I am doing a query formula and instead of " where C < 33" I would like my formula to reference a cell within my sheet. I have tired "where C< A1)" and "where C< value(A1)" with no luck.
2. Conditional formatting - I am having my cell change color based on the number I enter, but instead of the formatting saying "less than 50" and "greater than 30", I am wanting it to reference cell values once again. I am not sure what the custom formula would look like.
I am wanting to share my spreadsheet with multiple teachers with multiple grading thresholds. They have no excel knowledge to change formulas with their numbers, so I am trying to get a code written that will just have them insert their numbers into an empty cell on the worksheet.
Thank you for your help!
Two different things, but wanting the same result:
1. I am doing a query formula and instead of " where C < 33" I would like my formula to reference a cell within my sheet. I have tired "where C< A1)" and "where C< value(A1)" with no luck.
2. Conditional formatting - I am having my cell change color based on the number I enter, but instead of the formatting saying "less than 50" and "greater than 30", I am wanting it to reference cell values once again. I am not sure what the custom formula would look like.
I am wanting to share my spreadsheet with multiple teachers with multiple grading thresholds. They have no excel knowledge to change formulas with their numbers, so I am trying to get a code written that will just have them insert their numbers into an empty cell on the worksheet.
Thank you for your help!
