I have a table that returns a numerical value at the bottom only if all the requirements are met. If they are not it simply replies with 'FALSE' is there any way I can take this information and then on another page make it only print the numerical value. However, depending on what people input into the form it will change which column will have a numerical value. So it will need to read the 6 values decide which is a numerical value and then print it.
I also have conditional formatting on the cells so only the cell with a numerical value is coloured in yellow and the rest are red. Is there also any way of the computer reading these colours?
Thanks for your help,
Thomas
Bookmarks