Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a conditional format from one sheet to another?
I Track expenses from month to month in one excel doc. I have separate sheets
for each month, ant some totals sheets too. How can I copy a column that has a condititional format from one sheet to another? I tried copy than past special, but had no luck. The column had data already in it, and I just wanted the formatting. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a conditional format from one sheet to another?
Hi,
Paste special works for me, select formats option. If the formula was =IF(B2=2,TRUE) This will be the same and look at B2 on the next sheet you paste it into. -- This post was created using recycled electrons! "billz" wrote: I Track expenses from month to month in one excel doc. I have separate sheets for each month, ant some totals sheets too. How can I copy a column that has a condititional format from one sheet to another? I tried copy than past special, but had no luck. The column had data already in it, and I just wanted the formatting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format won't copy | Excel Discussion (Misc queries) | |||
VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
How do I copy a print format from sheet to sheet in excel ? | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |