Conditional Formatting

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