accessible
Technical User
Hi, I have been searching the site for 3 days but could not find an answer to my problem.
I have several tests in columns in a spreadsheet and dates are the rows.These tests are done at irregular intervals.When they are not performed there is nothing in the fields.When I enter a new row with today date, I want a kind of conditional formating for the tests which are overdue from ,let us say, 6 months or 1 year. I can not figure out how to do that.
Can you help?
Thank you
I have several tests in columns in a spreadsheet and dates are the rows.These tests are done at irregular intervals.When they are not performed there is nothing in the fields.When I enter a new row with today date, I want a kind of conditional formating for the tests which are overdue from ,let us say, 6 months or 1 year. I can not figure out how to do that.
Can you help?
Thank you