edit cell based on year

Forum|Forum|7 years ago
June 22, 2018
1 reply
441 views

Good morning ladies and gentlemen!

I recently created an inspection report which contains various 'Year service is due' fields. When I enter a past or present year, I'd like the cell background to turn red. If I enter a future year, I'd like the cell background to stay white. I don't know how to write code but I assume I can create a java script in this case. Can someone please assist?

Thank you in advance!

This topic has been closed for replies.

try67

Community Expert

Are you entering a full date (eg. "22/06/2018"), or just the year (eg. "2018")?

try67

Community Expert

Also, what should happen if the field is empty?

try67

Community Expert

Also, when I input a year less than 2019, the cell will remain light blue (fillable color). When I edit the year, it stays red background until the year is 2019 or after, but regardless of the year, the background remains light blue when not being edited.

You need to disable the fields highlighting option.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded