I can't seem to get this one.
I am trying to Highlight (color) C9 if greater than 0, and only when Todays date is 30 days or less before date in G5.
I tried what I could think of but can't come up with something with the two criteria.
Thanks
h.h.
vacation tracking LOG IWS 2006 TEST 1.xls | |||||||
---|---|---|---|---|---|---|---|
C | D | E | F | G | |||
1 | 9/14/06 | ||||||
2 | |||||||
3 | |||||||
4 | 4/20/06 | ||||||
5 | 20-Apr-06 | 20-May-06 | 20-Jun-06 | 20-Jul-06 | 20-Aug-06 | ||
6 | 120 | ||||||
7 | 8 | ||||||
8 | |||||||
9 | 112 | ||||||
7 YEAR EMPLOYEES |
I am trying to Highlight (color) C9 if greater than 0, and only when Todays date is 30 days or less before date in G5.
I tried what I could think of but can't come up with something with the two criteria.
Thanks
h.h.