Conditional Formatting

N

Nikhil

Hi

I have a conditional formatting applied to a range of cells for e.g. from
C4:D10

While the formatting works perfectly fine, if i try to move the data from
one cell to another (within this range), the formatting for that cells (where
i have moved the data , gets changed.

I want the conditional formatting to be retained and only the cell value to
be moved . How can i do it?

Thnks
 
A

alexrs2k

Hi.
Instead of moving the cell with left click, move it with right click
pressed. When prompt choosee the option: Copy here as value only. That's it.
 

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

Document Merge Formatting Issue 0
Printing Outline view - formatting lost 0
Conditional formatting with dates 7
Found few bugs in my daily routine of work in excel for MAC 0
display '2+2' as '4' in a cell? 5
Inconsistent formatting of section numbers 0
Conditional Formatting 1
Conditional formatting disappears when cell contents deleted 2

Top