Formulas don't work that way. They bring back values--not formats.

SueJ wrote:

Hi I am sure this is so simple but I am stuck!

In sheet one the cells are formatted with different fill colours and numbers
in them. I need to put a formulae in to different work sheets in the same
book that will pull through the number and also the fill colour. Can anyone
help please

--

Dave Peterson