select by data validation list to highlight the cells

[Anisusa]

Hi,

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".

[Anisusa]

Hi,

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".

hi can anyone reply for my post to solve the problems...

[joris moerings]

Hi,

Your question is really vague. You need to explain a little better what you expect. As example:

"IL" to highlight has blue

what cells do you need to turn up blue? Is it just column E or ......

[Anisusa]

Hi,
My question has been solved by Mr.joris thank a lot.

[Anisusa]

Hi,
My question has been solved by Mr.joris thank a lot.

[Anisusa]

sovled  

My question has been solved by Mr.joris thank a lot.

[joris moerings]

To mark your thread solved do the following:
New Method
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

[Anisusa]

thank u joris i did it...