I've tried to work this out myself via a search of old posts with no luck. I have column F filled with dates and column G filled with either Pending or Complete. I need them both (preferred), or at least the dates in column F, to turn yellow if the date in column F has passed AND column G in that row says 'Pending'. So, if I have:
F (Date) G (Status)
2) 12/5/03 Complete
3) 2/12/04 Complete
4) 1/19/04 Pending
5) 3/17/04 Pending
6) 2/30/04 Pending
7) 1/25/04 Pending
8) 1/15/04 Complete
I need rows 4 & 7, column F (hopefully G as well) to change to yellow.
Any help would be very much appreciated!
Jen
F (Date) G (Status)
2) 12/5/03 Complete
3) 2/12/04 Complete
4) 1/19/04 Pending
5) 3/17/04 Pending
6) 2/30/04 Pending
7) 1/25/04 Pending
8) 1/15/04 Complete
I need rows 4 & 7, column F (hopefully G as well) to change to yellow.
Any help would be very much appreciated!
Jen