Hi,
I am trying to do the following.
Thu Fri Sat Sun Mon Tue Wed
-----------------------------------------------------
Emp 1 V V 0 0 0 0 0
Emp 2 SL V 0 0 0 0 0
Emp 3 V V 0 0 0 0 0
FYI - V stands for Vacation and SL for Sick Leave.
Currently I am using the following 2 conditional formatting.
1> If the day = SAT or SUN then Mark a cell with one color Say RED
2> If there is a new entry of employee, Say EMP4 then do BOARDERS in that particular row from THU till WED.
On the top of the above 2 conditional formatting I want to do the following.
1> If the value in the cell = V ( Mark with one color )
2> If the value in the cell = SL ( Mark with other color )
3>
4>
....... and so on. There are total 8 possible values that can be entered.
Initially it looked very simple to me but I was not able to do it.
NOTE - The values that are populated in the cell i.e. V,SL etc changes as and when user selects a month from a given drop down. That is, for January The value in say C4 can be V where as for February C4 can be SL. The MACRO should take care of this and should change the color accordingly.
A QUICK RESPONSE TO THIS WILL BE HIGHLY APPRECIATED. Because I have created a Vacation Tracker for my project and we have not yet implemented just because of this one reason.
Thanks in advance.
Regards,
Javed.
I am trying to do the following.
Thu Fri Sat Sun Mon Tue Wed
-----------------------------------------------------
Emp 1 V V 0 0 0 0 0
Emp 2 SL V 0 0 0 0 0
Emp 3 V V 0 0 0 0 0
FYI - V stands for Vacation and SL for Sick Leave.
Currently I am using the following 2 conditional formatting.
1> If the day = SAT or SUN then Mark a cell with one color Say RED
2> If there is a new entry of employee, Say EMP4 then do BOARDERS in that particular row from THU till WED.
On the top of the above 2 conditional formatting I want to do the following.
1> If the value in the cell = V ( Mark with one color )
2> If the value in the cell = SL ( Mark with other color )
3>
4>
....... and so on. There are total 8 possible values that can be entered.
Initially it looked very simple to me but I was not able to do it.
NOTE - The values that are populated in the cell i.e. V,SL etc changes as and when user selects a month from a given drop down. That is, for January The value in say C4 can be V where as for February C4 can be SL. The MACRO should take care of this and should change the color accordingly.
A QUICK RESPONSE TO THIS WILL BE HIGHLY APPRECIATED. Because I have created a Vacation Tracker for my project and we have not yet implemented just because of this one reason.
Thanks in advance.
Regards,
Javed.
