How to copy a conditional format from one sheet to another?

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automatically paste cells from one sheet to another sheet? 1
Copy Conditional Formatting 1
Macros to copy and paste data 1
copy rows from one Data sheet to another sheet based on cell conte 2
Conditional Format Objects? 3
copying one sheet to another workbook 3
Copy a column and paste to another tab to save the data for each m 3
Copying Conditional formatting 2

Top