Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Problem
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Problem
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Problem
On 6 Oct, 15:07, 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 As has been already said, this is not possible (easily) with formulae, but if you were to group your work sheets together (shift or ctrl and then select worksheet tabs) you can apply the settings you want to all the worksheets at once ... Might help Matthew |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Problem
Hi Matthew - thank you. I do know about group mode but for this particular
job - that would not work - because the cells are going all over the place over the 13 sheets! I have had to settle for a macro - it works but looks very clumsy! thank you ;o) Sue "Matthew" wrote: On 6 Oct, 15:07, 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 As has been already said, this is not possible (easily) with formulae, but if you were to group your work sheets together (shift or ctrl and then select worksheet tabs) you can apply the settings you want to all the worksheets at once ... Might help Matthew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem loading Excel 2007 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |