Having trouble with IF(AND

PeggyLang

I have 2 columns of dates;

Column a = Target Date

Column b = Actual Date

I want to turn a cell 'Red' if Actual Date is blank and Target Date is either today or past.

The above formular returns 'INCORRECT ARGUMENT SET'.

Paul Newcome

You have a misplaced closing parenthesis. Try moving one from after the ISBLANK function to after [Target Date]@row.

Paul Newcome

You have a misplaced closing parenthesis. Try moving one from after the ISBLANK function to after [Target Date]@row.

PeggyLang

Gets me every time. Hopefully soon I'll get better at that part. THANK YOU.

Paul Newcome

Happy to help. 👍️