Hi,
I have a spreadsheet with a master worksheet containing columns that list staff names and the training completed and forklift licenses obtained and when those licenses expire.
Another worksheet refers to that master sheet and using nested IF statements populates the cells with the names of staff who have obtained their forklift licenses and when the licenses expire.
Is there any way that I can expand the IF statements (or add something else) to change the cell colour depending on how close each cell name is to the license expiry date? e.g. change the cell colour to orange if the expiry date is within 6 weeks from today's date, red if within 3 weeks, and so on.