Hello struggling with a conditional formatting any help would be appreciated.
So column be is populated 6 months (6 month from assigned date) from column G's (date assigned) date Trying to I would like
1. If number in column in G is from 1 to 2.0 months from correlation date of column b column B is amber ( or green for 76 days instead of 2.5 months)
2. If number in column in G is from 2.5 to 3.5 months from correlation date of column b column B is light pink (or turns yellow after 77 days instead 2.5
months)
3. If number in column in G is from 5 to 6 months from correlation date of column b column B is red (or turns yellow after 122 days instead 4
months)
4. If number in column in G is from 4 to 5 months from correlation date of column b column B is green (or turns yellow after 122 days instead 5
months)
See Attached. Thanks everyone.
Bookmarks