Conditional Formatting - Dates
Solved/Closed
BethanMary4
Posts
2
Registration date
Monday 5 February 2018
Status
Member
Last seen
6 February 2018
-
5 Feb 2018 à 11:47
BethanMary4 Posts 2 Registration date Monday 5 February 2018 Status Member Last seen 6 February 2018 - 6 Feb 2018 à 09:04
BethanMary4 Posts 2 Registration date Monday 5 February 2018 Status Member Last seen 6 February 2018 - 6 Feb 2018 à 09:04
Related:
- Conditional Formatting - Dates
- Excel clear formatting - Guide
- Conditional formatting excel dates - Guide
- Iphone 14 release dates - Home - IOS
- Vivatech 2024 dates - Guide
- Apple iphone 13 release dates - Guide
3 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
5 Feb 2018 à 12:21
5 Feb 2018 à 12:21
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
6 Feb 2018 à 05:21
6 Feb 2018 à 05:21
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 5 February 2018
Status
Member
Last seen
6 February 2018
6 Feb 2018 à 09:04
6 Feb 2018 à 09:04
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
6 Feb 2018 à 03:35