This may be a simple one, but I have conditional formatting usign a formula for each column of data I have, but when I move data around, like cutting and pasting G34 on to G50, the conditional formatting gets all crazy and dosn't work properly. I attached a before and after picture. Anyone know how to stop the conditional formatting from doing this?
short answer you cant ,when you cut you take the formatting with you
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
try copying and then pasting special/values only
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks