Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Help
.. Whenever I made changes in X, ...
You got it wrong. The updates are supposed to be made in Y, not X. X is the base reference. Pl read the earlier suggestion carefully. It should work as stated. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kaci" wrote in message ... Hello Max, I tried your method by using exactly X and Y worksheet, then using Col A, but it still does not work. Whenever I made changes in X, the Y worksheet does not show the conditional formating. Please kindly advise. "Max" wrote: .. all cells are non blank. Ah, sorry to have missed that earlier. It's considerably more difficult now, but to an extent, perhaps you could try this op/play .. Assuming source data is in col A in sheet: X Make a copy of X for the daily updates, name this sheet as say: Y In Y, Select col A (click on the col header "A") Click Format Conditional Formatting Under condition 1, make it as: Formula is: =A1<INDIRECT("'X'!A"&ROW(A1)) Click Format button Red fill n white font/bolded? OK Click OK at the main dialog When "updates" are made in col A, ie it's presumed the data values are changed to other/different values, then the cells will be formatted: Red fill n white font/bolded. If the update involves clearing data in Y, the format will also be triggered. Then at the end of each day, after you've noted whatever's triggered in Y, simply copy col A in Y and overwrite col A in X with a paste special as values. This readies Y for the next day's updates. In daily operation, X would/could be hidden safely away. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kaci" wrote: Hello, Thank you. However, all my cells are already filled with information, ie. all cells are non blank. So it does not work. What else can I do? All my cells are non blank, but I would like to know which cells have been changed by users. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation | Excel Worksheet Functions | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |