dstimpson
New Member
- Joined
- Nov 23, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
Hello,
I am looking to have a column of dates (column G) fill GREEN based off the conditions:
1. If there is a "P" (stands for portables) in column F
2. If the date listed in column G is over one year old (365 days+)
I am also looking to have the same column of dates (column G) turn GREEN based off the conditions:
1. If there is a "RI" in column F
2. If the date listed in column G is over 6 months
And vis versa for each but the columns would be turning RED if less than 1 year/6 months respectively
I appreciate any help!
I am looking to have a column of dates (column G) fill GREEN based off the conditions:
1. If there is a "P" (stands for portables) in column F
2. If the date listed in column G is over one year old (365 days+)
I am also looking to have the same column of dates (column G) turn GREEN based off the conditions:
1. If there is a "RI" in column F
2. If the date listed in column G is over 6 months
And vis versa for each but the columns would be turning RED if less than 1 year/6 months respectively
I appreciate any help!