Hello all,
Can I get some help on how to use VBA to highlight cells in a daily report that have approximately 500 lines with multiple date columns? Only need to high light cells in Column B if it's equal to or later/bigger than Column A but earlier/smaller than any of the following column C to F? For example:
What I would like to see:
Thanks for your help!
Can I get some help on how to use VBA to highlight cells in a daily report that have approximately 500 lines with multiple date columns? Only need to high light cells in Column B if it's equal to or later/bigger than Column A but earlier/smaller than any of the following column C to F? For example:
Date A | Date B (Column need to be highlighted) | Date C | Date D | Date E | Date F |
Jan 10 | Jan 9 | Jan 9 | |||
Jan 10 | Jan 11 | Jan 12 | Jan 12 | Jan 13 | |
Jan 15 | Jan 15 | Jan 9 | Jan 15 | Jan 13 | |
Jan 15 | Jan 16 | Jan 15 | Jan 16 | Jan 17 | |
Feb 1 | Jan 31 | Feb 1 | Feb 1 | Feb 1 |
What I would like to see:
Date A | Date B (Column need to be highlighted) | Date C | Date D | Date E | Date F |
Jan 10 | Jan 9 | Jan 9 | |||
Jan 10 | Jan 11 | Jan 12 | Jan 12 | Jan 13 | |
Jan 15 | Jan 15 | Jan 9 | Jan 15 | Jan 13 | |
Jan 15 | Jan 16 | Jan 15 | Jan 16 | ||
Feb 1 | Jan 31 | Feb 1 | Feb 1 | Feb 1 |
Thanks for your help!