You are reading a single comment by @Nef and its replies.
Click here to read the full conversation.
-
So the value for a3 wouldn’t be a calculation, but rather a point taken off a chart.
I’ve included a picture of the chart for 88-2, and you can see below 2A, the value is 33.1.The value for A3 is just a defined number that is a combination of type and rating.
On excel would it just be a case of putting all the values into the sheet somewhere, so you could say if a1=88-2, a2=2A, a3=z1 (z1 being where the relevant figure is recorded somewhere on the sheet).
1 Attachment
-
Nef
It's definitely possible (although realistically most stuff is in Excel depending how much effort you want to put in).
This may be what you're looking for with the drop-downs
https://trumpexcel.com/dependent-drop-down-list-in-excel/
Not quite sure where A3 is coming from, whether it's a formula or an existing set of data or something.
And something like this for colouring your cell red
https://www.ablebits.com/office-addins-blog/excel-conditional-formatting/