Want Arbitrary Row to conditionally disappear by comparing dates

[mmccleve]

My company got a new payroll processor. Employees are eligible to use Paid time off after their 90 day mark. She doesn't want any employee to show up from hire date + 90 days.

This is my initial formula. Column D contains the absolute hire date.

=IF(D391+90>TODAY(),"Not Eligible for PTO","Eligible")

Is there a way if the value in each row of column D + 90 is greater than today (), then that entire row conditionally gets hidden, or turns clear (or can't be seen).

Please let me know if I can clarify the question better, I can attach an example if necessary.

Thank you in advance for your help and consideration on educating me.

[dilipandey]

HI mmccleve,

Use the below formula in conditional formatting logic :-

Please Login or Register  to view this content.

See attached :-conditionally disappearing a row.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[mmccleve]

Thank you Sir,

I was right near the solution, but couldn't figure out how to apply it to rows. the $2:$100 was the missing piece. Thank you so much for your help!!

[dilipandey]

Just copy any row having conditional format and paste format to desired rows.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>