PC Review


Reply
Thread Tools Rate Thread

Association between cells

 
 
Walter Briscoe
Guest
Posts: n/a
 
      8th Nov 2010
I am using Excel 2003 on Vista.
I have a .xls provided to me.
On one sheet, cells(21,1), cells(21,2) and cells(21,3) have values.
cells(21,3) is a number.
When I change [21,3] to a value which is not a number,
the texts in [21,1] and [21,2] are changed in color from black to red
and they are crossed through with a line.
Writing "1.2 abcdef gh" to [21,3] has no effect; "1.2 abcdef ghi"
changes color, etc.

Can somebody suggest mechanisms which might have this result?
A dump tool to turn a .xls to a .txt might show the actual mechanism.
Can somebody please point to one?

As it happens, I can work around by writing [21,4] instead.
I am unhappy to find something I don't understand in the sheet.

No cells have validation - shown by edit/Go to/special/data
validation/all.

Ah ha! I've found it. [21,1] and [21,2] have conditional formatting.
[21,1] and [21,2] have Condition 1 as Formula Is =$C21>5 with a format
of strikethrough on a red background.

Selection.FormatConditions.Delete eliminates the conditional formatting.

--
Walter Briscoe
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create an association in set association control panel crazygirl Windows Vista Mail 8 5th Aug 2010 01:11 PM
Re: Association de fichiers /file association Peter Foldes Windows Vista General Discussion 1 18th May 2010 06:49 PM
Re: Association de fichiers /file association Gene E. Bloch Windows Vista General Discussion 1 18th May 2010 01:50 AM
File Association - unable to force association =?Utf-8?B?RGF2aWRN?= Windows XP General 4 30th Jun 2007 11:30 AM
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Microsoft Excel Worksheet Functions 2 19th Jul 2005 04:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:44 PM.