Highlight Employees with Over 5 Years Tenure
From Wikiprompt, the free prompt encyclopedia
Mar 24, 2026
Highlight Employees with Over 5 Years Tenure Formula for conditional formatting to highlight employees with tenure over 5 years.
Prompt ContentSave
🌐
I want to highlight employees in column B who have been at the company for more than 5 years. What formula should I use in conditional formatting to identify them?
Sign in to see the full prompt
Continue with:
By logging in, you agree to our Terms of Use and Privacy Policy
Usage
This prompt is designed for use with productivity. Copy the prompt content above and paste it into your preferred AI tool.
For best results, you may customize the placeholders (indicated by square brackets or capital letters) with your specific requirements.
Talk
0 comments