Dear Friends
I want to prepare leve chart . plese help me to solve it
Eg
A B C D
1 Fareez H N
2 Pathma
3 Rusdhi N H
I have entered staff name in cloumn and date in row. in this list Fareez is
back up for Rusthi. if rusthi takes leave , Fareez can not be allowed for
taking leave.

I am using " H" for annual Leave "N" means not allowed to take leave. if I
enter H for rusthi then autoimaticaly N sld come for Fareez and vice versa.
I used "If "function but not much support. please note that if I enter H for
Rusthi and If leave is cancelled later I sld be able to delete H without any
affect to formula that cell contains .
there is no must to use N if we can block that cell also fine

Please help me