dependancy problem

[littleme]

have a little question....

am creating a form where the architects keep track of their drawings. As the project advances changes are made the the different drawings are updated. After the first update, the drawings are labled A, after second, B and so forth. In the form, there is one column for the update "letter" and another with the date when the update was made. To prevent them from changing date, but not the letter, or vice versa, would like an error message to appear, or cell change color, when either date or letter is changed but not the other. does that make sense?

Alternatively a reminder should pop up when a change in either column is made...

any ideas....

Still need help with inserting the page numbers in the actual work space (not header/footer) and have multiple sheets in one worksheet....

nina

 

[macleanb]

Hi Nina


Kinda makes sense - kinda doesnt (And I'm still avoiding the page number question)

My main confusion/issue is that both updates cant be done at the same instant - so for a period your test will always be true - so you need to decide when to perform the test.

Could be via a button ?

I get the feeling that when you said form - you dont mean a user form, but rather a form built from a spreadsheet.


ttfn benm

 

[littleme]

good dodging the page number question =)

one error message/ warning too many is better that one to few i reckon, so...

isnt there a way to make it so that if a change, any change occurs in either cell, the other cell turns red, until enter is pressed from that now red cell? does that makes sense?

 

[macleanb]

You need to look at worksheet_change events - do a search in this forum for oodles of examples

 

[littleme]

Have done that but code is just not a language i understand.. or rather I can understand it when i read it, but writing it is totally different.. do not know the ins and outs of it SO, if anyone could help me with the above I would be over joyed.

If they changes somethins in column H, cell in same row in column J shades red, and they get automatically moved to column J regardless if choose tab or enter or whatever... shading goes away when J is changed as well...

PLEASE HELP!!!

 

[fairwinds]

Hi,

Some ideas that does not require code:

-Conditional formatting of J column. Example:
J4: "Formula is" =CELL("address")=(CELL("address",H4))


- Data validation
An input message or an information style error message.