VBA Code - Excel 2003
Closed - This job posting has been filled.
I need a VBA code for Excel 2003 version. I have attached a file that I have created with Excel 2007/2010 version(s) using conditional formating option. it is working fine. Need the same function that is working with the Excel version 2003 (it has ONLY THREE formating condition option, but I have FIVE conditions).
1. Column E (Gk.vezető): it is a drop down menu with 5 names (Name_1, Name_ 2, etc...).
2. When I select a Name from this menu, I'd like to colour that ROW (from column A to column I) with its colour specified (see atttached file please), when I select Name 2 the same scemario but with another colour and so on...
.3. I'd like to apply this VBA code to all the 5 sheets (Days)..
Thank you your help and work...