L
Legacy 50109
Guest
Hi there,
I am looking to create a tracking sheet, that would require a row of cells to change color after 30 minutes from the time the 1st series of text is inputted.
For example, I will have 2 columns. The 1st column is when I send out the documents, lets say is 2pm, but in order to keep the flow going smoothly, I need to receive a response within 30 minutes. The second column is when I receive it. If I don't receive a repsonse within 30 minutes I need the row to change color.
Is this possible, with the use of conditional formatting?
Thanks, David
I am looking to create a tracking sheet, that would require a row of cells to change color after 30 minutes from the time the 1st series of text is inputted.
For example, I will have 2 columns. The 1st column is when I send out the documents, lets say is 2pm, but in order to keep the flow going smoothly, I need to receive a response within 30 minutes. The second column is when I receive it. If I don't receive a repsonse within 30 minutes I need the row to change color.
Is this possible, with the use of conditional formatting?
Thanks, David