Scooter172
02-06-2012, 08:20 PM
I have a schedule in Xcel that I want a row say 1-17 colums c-h and its contence to change colors based on if the information in Column B1:B17 matches the information in Cells B23:B25.
This would blank out the schedule of hours and days in all columns in that row of Person a in row who is indicated on Vacation in Cells in B23:B25
B1 = B23 so therefore row 1 C1 - H1 turn a color
I want to use conditional formatting but can this be done without a Macro, would this be better served using a cond format based on formula?
I have already named tha ranges of B1:B17 as Scheduledetail and B23:B25 as OnVacation
This would blank out the schedule of hours and days in all columns in that row of Person a in row who is indicated on Vacation in Cells in B23:B25
B1 = B23 so therefore row 1 C1 - H1 turn a color
I want to use conditional formatting but can this be done without a Macro, would this be better served using a cond format based on formula?
I have already named tha ranges of B1:B17 as Scheduledetail and B23:B25 as OnVacation