So with the free Numbers app for my iDevices, I've started looking into switching from Excel to Numbers since my needs are pretty basic and being able to edit on the go is more important than all the functions in Excel that I won't use...
But I'm stuck at one very annoying detail: being able to have the document auto fill the background using two colours...
For instance, I want a column of numbers to be filled with red and green. Red being for the lowest value, green being for the highest value, and gradients of red and green for the rest of them. This is great for easy comparison of different values at a glance.
This is very, very simple to do in Excel. You just choose two colours, have one be for the highest value and the other for the lowest value, and it's done. But I can't seem to find a way to do this in Numbers. Is it even possible?
But I'm stuck at one very annoying detail: being able to have the document auto fill the background using two colours...
For instance, I want a column of numbers to be filled with red and green. Red being for the lowest value, green being for the highest value, and gradients of red and green for the rest of them. This is great for easy comparison of different values at a glance.
This is very, very simple to do in Excel. You just choose two colours, have one be for the highest value and the other for the lowest value, and it's done. But I can't seem to find a way to do this in Numbers. Is it even possible?