[libreoffice-users] Calc function

I am trying to automatically remove a number from a range of cells, if it 
appears in a different range.

I am creating a spreadsheet where once a number appears in B4:G11 4 times, it 
changes color to Red.......got that part.

Then I want to manually enter that number somewhere into J4:N21. once entered 
into J4:N21, i want that number to erase from B4:G11.

ideally at that point i would also like all remaining numbers in B4:G11 to 
shift up, leaving no empty cells above cells with values in them (keeping them 
in the order entered within columns).




-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted