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

Excel Conditional Formatting Removal 7
Excel Highlighting duplicates 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional Formatting 3
Copy and Paste Conditional Formatting 3
Conditional Formatting Font Change 1
#N/A Conditional Formatting affects all cells? 9
display '2+2' as '4' in a cell? 3

Top