Conditioning Formatting

Chamberlyn Posts 4 Registration date Sunday November 25, 2012 Status Member Last seen December 19, 2013 - Dec 19, 2013 at 01:39 AM
 Blocked Profile - Dec 19, 2013 at 09:30 AM
HI All,

we have mandatory annual training requirements and I have a spreadsheet which records the date training has been completed.

we have several different courses that must be done either annually or every 2nd year. As we have a number of staff I would like to use a conditioning format which causes the date to highlight when the training is due to be redone. The date recorded is the date the course was last completed.

I have tried several different formulas but have not been able to achieve the result I want. Any suggestions would be good.

1 response

Blocked Profile
Dec 19, 2013 at 09:30 AM
Good Morning.

Just try the built in conditional formatting on the tool bar.

You can right your own logic for how it formats and when, and it is simple.

Give it a try, let me know if you get stuck.

Please post back.