I'd like to be able to use data that is entered onto worksheet to produce a
number of charts, but only want each chart to use data from cells that are
formatted in a certain fill colour. On other words, one chart might use data
from cells coloured red, another chart from cells coloured green etc. is this
possible and how would I go about doing it?

Any help gratefully appreciated