Cut & Paste Conditional Formatting

N

Neon520

Hi Everyone,

I have set conditional formatting for a range for column: =MOD(ROW(),2) and
choose grey color, so that the row will appear as one white and the next one
is grey.

The thing is when I do Cut and Paste the color has gone away even though the
Conditional Formatting is still in place, but the color is gone. Any idea to
let the color stay when doing Cut and Paste.

I've worked around it by COPY and PASTE and then delete the previous entry,
but it's just so inconvenience to go back and forth to delete the old ones.
But the Cut and Paste don't work!!!!!

Help!!!!!
Thanks,
 
N

Neon520

I'm using Office 2004 for Mac.
After Cut and Paste and I check the CF, it's still there, but the color is
just gone.
What's going on?
 

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

Top