Highlight cells based on a specific day of the month
Closed
trentseibel
Posts
1
Registration date
Thursday March 6, 2014
Status
Member
Last seen
March 6, 2014
-
Mar 6, 2014 at 01:23 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 10, 2014 at 12:07 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 10, 2014 at 12:07 PM
Related:
- Highlight cells based on a specific day of the month
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Excel if range of cells contains specific text ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Find values based on colum and sum in a table - Office Software Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Mar 10, 2014 at 12:07 PM
Mar 10, 2014 at 12:07 PM
Hi Trentseibel,
You probably figured you have to use conditional formatting and are wandering what the formula's would be, right?
1) =A1-DAY(TODAY())<=0 [red]
2) =AND(A1-DAY(TODAY())>=1,A1-DAY(TODAY())<=7) [yellow]
For your second question, how do we know which month it is?
Best regards,
Trowa
You probably figured you have to use conditional formatting and are wandering what the formula's would be, right?
1) =A1-DAY(TODAY())<=0 [red]
2) =AND(A1-DAY(TODAY())>=1,A1-DAY(TODAY())<=7) [yellow]
For your second question, how do we know which month it is?
Best regards,
Trowa