i am creating a leave planner sheet i have a confuse to enter formula can u pls solve me....below 3 points.
1) i have a data validation list ( choice of 3) in column "E" if select "AL" to highlight has green , "IL" to highlight has blue , "Sl" to highlight has brown.
2) in Holidays sheet i have yearly holiday list once i date enter to highlight the color has gray in leave calender in "yearly planner" sheet.
3) in column "A" data validation by selecting grade if above 10 grade i select the holidays list to add 1 to in-leu days in column "AU8".
i posted in other forums but still i didnt get any response.... as any one can solve this .....