Data validation

[ramana.bpc]

hi gurus,

A1 = 10
A2 = 2
A3 = 5
A4 = 1
i want an error message (validation) when the sum of A2:A4 is not equal to A1.
Please advice how to achieve this

Regards
Ramana

[Rahul Nagar]

Hi,

Please check the attached file.
I think this would help you.

[ramana.bpc]

Hi Rahul,

thanks for the quick reply but my requirement is a bit different. I need a pop up message for this.
(Data -- > Data validation)

Thanks
Ramana