How to display alert message in Excel 2007
 

Hi,
This is Zameer, please suggest me how to write a condition in Excel
2007.
I prepared Attendance for staff. Two sheets are there one is January
and second one is Leaves Summary. I am using dropdown list (P, CL, CF,
ML, EL) in January sheet. If I select in a cell as CL then I want to
go Second sheet check, whether the person have CFs or not. If have
get the message (Title "suggistion", subject: "There is CFs
available).. If dont have CFs then check CLs and get the message
same. If dont have CLs then check the Medical Leaves (ML). If have
get the message or dont have check the ELs.

If possible please give me suggistion.

Thanks in advance....
Friend for all