Needtoknowit1
Posts Wednesday August 12, 2015Registration date
August 12, 2015
Last seen
-
Aug 12, 2015 at 03:01 PM - Latest reply: Ambucias51708
Posts Monday February 1, 2010Registration dateModeratorStatus
May 21, 2018
Last seen
- Aug 12, 2015 at 05:49 PM
I have three date columns in a sheet, order date, approved date and received date.
I want the ordered date to be green but going red if not approved within 14 days. If approved within 14 days it should stay green
Then the approved date to be green but going red if the not received within 30 days but stay green if received within 30 days
Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.
Therefore, it is specifically requested from CCM forum users to correspond showing mutual respect. Therefore, when requesting assistance, to be courteous, as for elsewhere in similar circumstances. (i.e. please, thank you, appreciate, grateful, etc.)
