Previous Topic Next Topic

Conditional formatting using dates in different cells

Solved/Closed
rbarletta Posts 2 Registration date Tuesday March 5, 2013 Status Member Last seen March 6, 2013 - Mar 5, 2013 at 03:58 PM
rbarletta Posts 2 Registration date Tuesday March 5, 2013 Status Member Last seen March 6, 2013 - Mar 6, 2013 at 12:38 AM
Hello,

I need help with a problem that is driving me insane.

I have column A, B, and C

A is date started
B is date finished
C is days it took to complete

Using "=TODAY()-$A4" I have computed the days worked.

I need to use C.F. so that if there is a finished date in the column B cell then the column C cell is blank ... I am only trying to mark cells in column C that are over 30 days without a closed date in the corresponding B cell ...

Any and all help are truly appreciated!!!

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 5, 2013 at 11:23 PM
First how would I do it :-)

A1: is date started (required)
b1: is date finished (optional)

C1: days worked
=IF(A1="","",IF(B1<>"",b1-a1,today()-a1))


Now on to your question
=and(a1<>"",b1="",today()-a1>30)
1
Answer 2 / 2
rbarletta Posts 2 Registration date Tuesday March 5, 2013 Status Member Last seen March 6, 2013
Mar 6, 2013 at 12:38 AM
Thank you for a quick response.

Worked exactly how I needed it to!!!

Such a big help!!! Thank you!
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses