Hello, I've used OpenOffice word for a while now, and have started using Spreadsheet for a few things. One of the problems I've run into, and one I cannot seem to find a solution for by Googling, is a way to do as the subject reads: "Getting the value of a named field by getting the value from a nearby field".
It might sound complicated, but the idea is quite simple, and I'm hoping the implementation for it will be too. I have a lot of data I copy and paste (some 100 or more times), and I can't afford to have myself or others who use the spreadsheet to go in and edit the Conditional Formatting for certain fields each time they add a new item, so I'm hoping to create something which does the following (example fields) ----------------------------------------- | Rank (A1) | 12 (A2) | ------------------------------------------ What I need to get at is the named cell 'Rank' in another sheet. So I tried something like this in the conditional formatting applied to the 12 field if field value | is greater than | '$A1' (and many similar variations) I'm wanting it to parse like this when run: if field value | is greater than | Rank <- the named cell The idea is that if I change the string Rank in the field beside it to say, Defence (yes, a game spreadsheet if you hadn't guessed yet), then it'll still be able to have the conditional if field value | is greater than | '$A1' But instead this time it'll parse as: if field value | is greater than | Defence The benefit is being able to copy and paste the same conditional anywhere in the document, and only change the cell value next to it (which is faster than editing the conditional). So, I hope I explained myself well enough. Is there any way to do this? Here are my current test lines for the conditional (none of which work). I'm hoping someone might know, or at least if this is even possible. '$Sheet2.$A$1' INDEX($Sheet2.$A$1) LOOKUP($Sheet2.$A$1, $Sheet1.$A$1:$Sheet1$A$10) $Sheet1.'$Sheet2.$A$1' etc. I'm hoping you can help. Thanks in advance. Regards Kieran
