Skip to main content
SteveAzevedo
Participating Frequently
June 22, 2018
Question

edit cell based on year

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 is closed to new replies. Start a new post to keep the conversation going.

11 replies

try67
Community Expert
Community Expert
June 22, 2018

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

Translate
try67
Community Expert
Community Expert
June 22, 2018

Also, what should happen if the field is empty?

Translate
SteveAzevedo
Participating Frequently
June 22, 2018

Remains white.

[Moderator Note: Personal information removed. Please turn off email signatures when replying to forum posts.]

Translate