I have looked and tried, and no luck.
I need A3 to do 2 things
When the arrival date is less than the number of days allowed to turn red.
so it will turn red when a date is entered and also turn red automatically using today's date.
A1 has arrival date
A2 Has drop down list with 1 day, 3 day, 5 day. (I can remove "day", if that helps) (same document sheet called Data)
A3 to turn red...this is where I'll add the received date
<tbody>
</tbody>Both cell are filled red, I didn't see an option.
Excel 2010 & 2013
Thanks Excel Wonder workers...I'm about 2 hours into trying ..no luck
I need A3 to do 2 things
When the arrival date is less than the number of days allowed to turn red.
so it will turn red when a date is entered and also turn red automatically using today's date.
A1 has arrival date
A2 Has drop down list with 1 day, 3 day, 5 day. (I can remove "day", if that helps) (same document sheet called Data)
A3 to turn red...this is where I'll add the received date
Arrival | Allowed days | arrived |
08/01 | 2 | 08/05 |
08/01 | 3 | Cell filled red |
<tbody>
</tbody>
Excel 2010 & 2013
Thanks Excel Wonder workers...I'm about 2 hours into trying ..no luck