I am currently using this formula it does work but doesnt do what i need it to:
currently its just selecting the true or false information and using conditional formatting im changing the colours of the cells,
However, i want to include another condition which i cannot seem to get to work this is:
if the completed by date is greater than todays date which i already have in a cell i want it to override the true or false and put incomplete, ive tried various things and cant seem to get it working can anyone help!!?
thanks in advance