Puzzled

  • Thread starter Cowtown Kev - ExcelForums.com
  • Start date
C

Cowtown Kev - ExcelForums.com

A spreadsheet I am using is colouring cells yellow when I drag dat
fron the cell and drop it elsewhere

i.e

Cell A1 has data say xyz in white background, if I drag that data t
say A2, Cell A1 is coloured yellow and cell A2 is as original

It is only happening on this one particular spreadsheet and is drivin
me insan
 
M

Max

One thought .. think there's no harm checking if
there's underlying conditional formatting applied ..

Try this on a spare copy of your book:

Press F5 > Special > Check "Conditional Formats" > OK
(this'll select all cells with C.F.)

Click Format > Conditional Formatting
Click Delete button > Check to remove all conditions > OK
 
M

Max

So .. it's not conditional formatting then <g>
maybe you'd like to try this (on a *spare* copy)
to exclude macros ?..
(Note: this'll delete macros)

Right-click on the sheet tab > select View code
This'll bring you to the VBE screen (Sheet module)
In the code window on the right-side
delete everything there

Locate your file in the top left "Project" window in VBE
(will read something like: VBAProject (<Yourfilename>))
Right-click on "ThisWorkbook"
(inside the Microsoft Excel Objects folder)
Select View code
In the code window on the right-side
delete everything there (in the ThisWorkbook module)

Open the Modules folder
Right-click on each module inside (in turn) > View code
In the code window on the right-side
delete everything there

Exit VBE/return to Excel (press Alt+Q)

Hope that'll help, but do hang around
a while here for insights from others
 
M

Max

You're welcome
Sorry it wasn't of much help ..

Maybe others would lend you some insights

... and perhaps you may like to send a copy of
the book over via private email to:
xdemechanik <at>yahoo<dot>com
(with or without the preceding "x" is okay, both are valid)

Drop a line here to alert me if you're sending
 
Top