Column B "6 month from Assigned Date" is based on column E's assigned date with =EDATE(E60,6). What I would like
From Column e from 0-30 days green in column B
31-100 days Amber
100-180 days red
Can not figure out format can someone assist?
Column B "6 month from Assigned Date" is based on column E's assigned date with =EDATE(E60,6). What I would like
From Column e from 0-30 days green in column B
31-100 days Amber
100-180 days red
Can not figure out format can someone assist?
what are we comparing those dates to
Column E compared to TODAY() date
see attached example
Green
=E1>=TODAY()-30
Amber
=E1>=TODAY()-100
RED
=E1>=TODAY()-180
in that order , in conditional format
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks