Spreadsheet: 133206d1324277837-using-conditional-formatting-to-highlight-celss-vacationrecord2011_example
Sheet: 1

VACATION RECORD 2011 (YTD)
Name | ID | Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Days | StDt1 | EndDt1 | StDt2 | EndDt2 | [NAME] | EndDt3 | StDt4 | EndDt4 | StDt5 | EndDt5 |  |  |  |  |  |  |  |  | SUMMARY | NAME | ID # | TOTAL DAYS | AVAILED YTD | BALANCE DAYS
PHILIP |  | January | Refers to dates from AJ4 to AK4 |  |  |  |  |  |  |  |  |  |  |  |  |  | Refers to AL4 to AM4 |  |  |  |  |  |  |  | Refers to AN4 to AO4 |  |  |  |  |  |  |  |  |  | 1 | 7 | 15 | 17 | 23 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | PHILIP | 26446 | 42 | 13
EVANGELINE |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 7 | 12 | 14 | 21 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | EVANGELINE | 26300 | 42
LEA |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 15 | 19 | 25 | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  | LEA | 26294 | 42
DEXTER |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4 | 8 | 10 | 19 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | DEXTER | 26508 | 42
[NAME] |  | March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 13 | 21 | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 26527 | 40
MARILOU |  | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | 10 | 11 | 15 | 16 | 22 | 23 | 29 | 30 |  |  |  |  |  |  |  |  |  | ARNULFO | 26534 | 40
MARIA |  | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7 | 13 | 17 | 24 | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  | MARILOU | 26748 | 40
ARNULFO |  | May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | 10 | 14 | 19 | 21 | 25 | 27 |  |  |  |  |  |  |  |  |  |  |  | MARIA | 26837 | 40
[NAME] |  | May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 13 | 15 | 21 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 28010 | 40
FRANCISCO |  | May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4 | 9 | 11 | 29 | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  | FRANCISCO | 28224 | 30
ARNULFO |  | June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 14 | 22 | 29
MARIA |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 8 | 16 | 19 | 28 | 31
DEXTER |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 23 | 30 | 31
[NAME] |  | September |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 12 | 26 | 29
FRANCISCO |  | October |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 16 | 22 | 27
MARIA |  | November |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6 | 15 | 16 | 24 | 26
 |  |  |  |  |  |  |  | This result with a more sophisticated formula will be great
 |  | Highlighting with Contional Formatting needed