Puzzled

  • Thread starter Thread starter Cowtown Kev - ExcelForums.com
  • Start date 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
 
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
 
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
 
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
 
Back
Top