I have a sheet which contains all our jobs (job names in col A). In Col B we have a data validation list with several job statuses in - "Waiting", "Live", "Finished", "Archived" and these change over time. In Col C we have a due date.
I want that due date to change colour (say to Red and Bold) if it is equal or less than today - i.e. the due date is either today or has passed (that's all easy enough). However I want the colour change to happen based on multiple job statuses as well.
i.e. if the job status is "Waiting" or "Live" AND the date is equal or less than today then apply the CF. If its any other status then leave it as it is.
I'm assuming I need to apply a formula to the CF but struggling to get it right for multiple criteria.
Hope that makes sense.
I want that due date to change colour (say to Red and Bold) if it is equal or less than today - i.e. the due date is either today or has passed (that's all easy enough). However I want the colour change to happen based on multiple job statuses as well.
i.e. if the job status is "Waiting" or "Live" AND the date is equal or less than today then apply the CF. If its any other status then leave it as it is.
I'm assuming I need to apply a formula to the CF but struggling to get it right for multiple criteria.
Hope that makes sense.
