Formatting colours
Closed
Shaggy1972
-
Mar 13, 2012 at 07:09 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 19, 2012 at 11:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 19, 2012 at 11:05 AM
Related:
- Formatting colours
- 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
- Rj45 colours - Guide
- Phone formatting software for pc - Download - File management
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Mar 19, 2012 at 11:05 AM
Mar 19, 2012 at 11:05 AM
Hi Shaggy,
When start date is in A1 and Today date is in B1, then apply conditional format to A1 with the following formula:
Trowa
When start date is in A1 and Today date is in B1, then apply conditional format to A1 with the following formula:
=B1-A1>=182Best regards,
Trowa
