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
Hello,

Hi everyone - I am looking to show in Excel when a person has worked for me more than 182 days(26 weeks)
Ie;
Start date Today Date
22/05/11 13/03/12
Start date to change colour when 182 days(26 weeks) has been completed.
Please help

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
Hi Shaggy,

When start date is in A1 and Today date is in B1, then apply conditional format to A1 with the following formula:
=B1-A1>=182
Best regards,
Trowa
0