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

edit cell based on year

  • 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.

1 reply

try67
Community Expert
Community Expert
June 22, 2018

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

try67
Community Expert
Community Expert
June 22, 2018

Also, what should happen if the field is empty?

SteveAzevedo
Participating Frequently
June 22, 2018

Remains white.

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