Search:

My apologies, I have forwarded you a new chart.

Its emailed. You just reply and I'll review it Monday.

The formula is acting as chaotic as the formula I had initially. It does show that the formula is moving chronological, but some cells that should be highlighted are not and vice versa. I assumed I...

I know I may copy and special paste from CELL IS in CONDITIONAL FORMATTING to the remaining 2000 rows. May I copy and special paste from FORMULA IS to the remaining 2000 rows?

I normally use the Cell Value Is where I am able to copy and special paste to all 2000 rows. I can not copy and special paste using the Formula Is.

I need Conditional Formatting to only highlight dates that exceed 50 years of age. Currently I have =((TODAY()-D4)/365<50). It seems to work on some but not all, any suggestions.

A new parameter is employees are prohibited to retire until they reach 50 although they met the 75-year rule. E.G. I have information in columns A-F; in column G I posted the...

I added a conditional format to highlight employees over 75 and it works great. Again thank you for your patience.

Perfect thank you, changing the format to general activated the formula.

When I input
=((TODAY()-A1)/365)+((TODAY()-B1)/365)
I continually get 5/16/2010 18:52 and other similar values.

Actually having an abutting column designating the eligible year would be nice.

I have attempted the YEARS and DATE function with unsuccessfully.

I have tried the function year different possibilities. Do you use the YEAR, DATE or other function?

Actually it is age + years=75 for retirement unless you are 62 years old and 5 years tenure.

For excel to maintain continually update daily; the age would have to count down (decrease) AND (-) the...

I thought there it was a two part; age counting down (FALSE) and the second date was when they started working so it would go up (TRUE).

Adding the two would offer you the number of years until...

We use Microsoft Office 2003 at our office. Our company computes the employees’ age, e.g. (01/01/1949) plus their starting date, e.g. (08/22/1989) to check if they are eligible for the 75 rule for...