Formatting colours
Closed
Shaggy1972
-
13 Mar 2012 à 07:09
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Mar 2012 à 11:05
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Mar 2012 à 11:05
Related:
- Formatting colours
- Excel clear formatting - Guide
- Low level formatting - Download - Storage
- Hp formatting tool - Download - Storage
- Formatting sd card to fat32 - Guide
- Formatting windows 7 - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
19 Mar 2012 à 11:05
19 Mar 2012 à 11:05
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
