Need help with conditional formatting.
Closed
JessaSteele
-
Aug 11, 2016 at 12:37 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 11, 2016 at 02:52 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 11, 2016 at 02:52 PM
Related:
- Need help with conditional formatting.
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- How to format windows 7 with keyboard - Guide
- Formatting usb mac - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 11, 2016 at 02:52 PM
Aug 11, 2016 at 02:52 PM
JessaSteele, God afternoon.
Conditional formatting works only for aesthetic characteristics of the cells.
This is not the case.
Suppose:
A1 --> Date Placed
B1 --> End Date --> Formula
Try to use:
B1 -->
=IF(A1="","",EDATE(A1,6))
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Conditional formatting works only for aesthetic characteristics of the cells.
This is not the case.
Suppose:
A1 --> Date Placed
B1 --> End Date --> Formula
Try to use:
B1 -->
=IF(A1="","",EDATE(A1,6))
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão