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

Edit cell based on year entered

  • June 22, 2018
  • 1 reply
  • 1039 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

    sinious
    Legend
    June 23, 2018

    First thing we need to know is what are you trying to add a script to. A web page, PDF, etc?