View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bluesifi bluesifi is offline
external usenet poster
 
Posts: 13
Default Validation - Ensure Cell values match

Hi

I have a spreadsheet, and need to ensure that the value in a number of cells
are the same.

Example
Cell C1 shows the total number of open Problem. Table Two has All Open
Problems by Age with a check Sum in Cell D5. The Value in Cell C1 & D5
should be the same. I would like a warning message to be displayed before
you save or exit the sheet, if the two values are not the same

Is this possible