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

You need to disable the fields highlighting option.


try67...thank you so much - that was the problem! Thank you for the quick response and patience. Have a great day!