J
John
I want to calculate time passed by subtracting one date from another and put
the time in hours and minutes in a cell. If the value in the cell is greater
than a value in another cell, then I want to turn the first cell red. If it
is equal to or less, then turn the cell green.
A1 B1 C1
D1
Date Date Subtract A1 from B2 and If C1
greater than D1,
put answer in C1 in hours and minutes make C1
Red. If not
Make C1 Green
the time in hours and minutes in a cell. If the value in the cell is greater
than a value in another cell, then I want to turn the first cell red. If it
is equal to or less, then turn the cell green.
A1 B1 C1
D1
Date Date Subtract A1 from B2 and If C1
greater than D1,
put answer in C1 in hours and minutes make C1
Red. If not
Make C1 Green