Previous Topic Next Topic

Formatting colours

Closed
Shaggy1972 - Mar 13, 2012 at 07:09 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - 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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Reversing background colour and text colouring?
WesternGuy -
WesternGuy -

2 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses