Related:
- Conditional Formatting
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Conditional format based on another cell containing text - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
- Highlight cell if another cell contains specific text - Excel Forum
1 reply
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2023
146
Oct 28, 2016 at 01:55 PM
Oct 28, 2016 at 01:55 PM
Snowhite66, Good afternoon.
Try to use:
K6 --> =IF(J6="", "", J6+30)
L6 --> =IF(K6="", "", TODAY()-K6)
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
K6 --> =IF(J6="", "", J6+30)
L6 --> =IF(K6="", "", TODAY()-K6)
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Oct 31, 2016 at 10:17 AM
Thank you for your answer, unfortuantely I can get this work :-(
Oct 31, 2016 at 11:27 AM
On the cell
=IF(J6=0,"N/A", (K6-TODAY()))