Formating for dates past

Garethpjohnson

I'm looking to set a rule for when my 'Finish' date column pass my 'Completion' date column. When I try to set the rule it only allows me set when passes a fixed date rather that a date set in a certain column? 

any help welcome. 

thanks 

G

Chris McKay

Hi Gareth,

What you're proposing is absolutely possible. Are you receiving an error?

The formula you're looking for will be something like:

=IF(Finish1 > Completion1, "True", "False")

You'll need to make sure you're comparing the same column types, so both Finish and Completion will have to be Date formatted columns.

Kind regards,

Chris McKay