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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top