Conditional Formatting - Dates
Solved/Closed
BethanMary4
Posts
2
Registration date
Monday February 5, 2018
Status
Member
Last seen
February 6, 2018
-
Feb 5, 2018 at 11:47 AM
BethanMary4 Posts 2 Registration date Monday February 5, 2018 Status Member Last seen February 6, 2018 - Feb 6, 2018 at 09:04 AM
BethanMary4 Posts 2 Registration date Monday February 5, 2018 Status Member Last seen February 6, 2018 - Feb 6, 2018 at 09:04 AM
Related:
- Conditional Formatting - Dates
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Formatting usb mac - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 5, 2018 at 12:21 PM
Feb 5, 2018 at 12:21 PM
BethanMary4, Good afternoon.
Try to use:
Select N1:N100 (as your necessity)
Conditional Format --> Using formula -->
=AND(TODAY()-N1<=42;N1-TODAY()<=42)
--> Format: Fill color as desire
OK
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Try to use:
Select N1:N100 (as your necessity)
Conditional Format --> Using formula -->
=AND(TODAY()-N1<=42;N1-TODAY()<=42)
--> Format: Fill color as desire
OK
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 6, 2018 at 05:21 AM
Feb 6, 2018 at 05:21 AM
BethanMary4, Good morning.
Maybe this is about of separator sign of your system:
Try to use COMMA ( , ) instead of SEMICOLON ( ; )
Old --> =AND(TODAY()-N1<=42 ; N1-TODAY()<=42)
New --> =AND(TODAY()-N1<=42 , N1-TODAY()<=42)
Please, tell us if it's working now.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Maybe this is about of separator sign of your system:
Try to use COMMA ( , ) instead of SEMICOLON ( ; )
Old --> =AND(TODAY()-N1<=42 ; N1-TODAY()<=42)
New --> =AND(TODAY()-N1<=42 , N1-TODAY()<=42)
Please, tell us if it's working now.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
BethanMary4
Posts
2
Registration date
Monday February 5, 2018
Status
Member
Last seen
February 6, 2018
Feb 6, 2018 at 09:04 AM
Feb 6, 2018 at 09:04 AM
It's ok, I figured it out.
I've done
"format only cells that contain"
cell value less than or equal to TODAY()-42
I've done
"format only cells that contain"
cell value less than or equal to TODAY()-42
Feb 6, 2018 at 03:35 AM