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
rbarletta Posts 2 Registration date Tuesday March 5, 2013 Status Member Last seen March 6, 2013 - Mar 6, 2013 at 12:38 AM
Related:
- Conditional formatting using dates in different cells
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
- Based on the cell values in cells b77 - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 5, 2013 at 11:23 PM
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)
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)
rbarletta
Posts
2
Registration date
Tuesday March 5, 2013
Status
Member
Last seen
March 6, 2013
Mar 6, 2013 at 12:38 AM
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!
Worked exactly how I needed it to!!!
Such a big help!!! Thank you!
